APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on PAY_ELEMENT_ENTRIES_F

Line 95: , pay_element_entries_f pee

91: FROM per_people_f pap /* Bug 4925794 */
92: , per_all_assignments_f paa,/*Bug 3012794*/
93: hr_soft_coding_keyflex hsc,
94: per_periods_of_service pps
95: , pay_element_entries_f pee
96: , pay_element_types_f pet
97: , pay_input_values_f piv0
98: , pay_element_entry_values_f eev0
99: , pay_input_values_f piv1

Line 147: ,pay_element_entries_f pee1

143: AND pee.effective_start_date =
144: (SELECT max(pee1.effective_start_date)
145: FROM pay_element_types_f pet1
146: ,pay_element_links_f pel1
147: ,pay_element_entries_f pee1
148: WHERE pet1.element_name = 'Tax Information'
149: AND pet1.element_type_id = pel1.element_type_id
150: AND pel1.element_link_id = pee1.element_link_id
151: AND pee1.assignment_id = paa.assignment_id

Line 248: pay_element_entries_f pee,

244: hr_soft_coding_keyflex hsc,
245: pay_element_entry_values_f pev,
246: pay_input_values_f piv,
247: pay_element_types_f pet,
248: pay_element_entries_f pee,
249: hr_lookups hrl0
250: WHERE pet.element_name = 'Superannuation Guarantee Information'
251: AND pet.element_type_id = piv.element_type_id
252: AND pev.input_value_id = piv.input_value_id

Line 263: FROM pay_element_entries_f pee1

259: AND hrl0.lookup_type (+) = 'YES_NO'
260: AND hrl0.lookup_code (+) = pev.screen_entry_value
261: AND hrl0.enabled_flag (+) = 'Y'
262: AND pee.effective_start_date = (SELECT max(pee1.effective_start_date)
263: FROM pay_element_entries_f pee1
264: WHERE pee1.element_entry_id = pee.element_entry_id
265: AND pee1.effective_start_date <= c_report_end_date
266: )
267: AND paa.effective_start_date = (SELECT max(effective_start_date)