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 148: ,pay_element_entries_f pee1

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

Line 250: pay_element_entries_f pee,

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

Line 266: FROM pay_element_entries_f pee1

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