What are the rules on tense mixing in fiction writing?

Simple:-)


- in a sea of  simple past tense: the time pipelines leading to it should be in past perfect; the remote events should be in past perfect or simple past

- in a sea of  present narrative tense: the time pipelines leading to it should be in present perfect; the remote events should be in simple past



Ladies and Gentlemen, start your exceptions!