APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 98: , pay_element_entry_values_f eev0

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
100: , pay_element_entry_values_f eev1
101: , pay_input_values_f piv3
102: , pay_element_entry_values_f eev3

Line 100: , pay_element_entry_values_f eev1

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
100: , pay_element_entry_values_f eev1
101: , pay_input_values_f piv3
102: , pay_element_entry_values_f eev3
103: , pay_input_values_f piv4
104: , pay_element_entry_values_f eev4

Line 102: , pay_element_entry_values_f eev3

98: , pay_element_entry_values_f eev0
99: , pay_input_values_f piv1
100: , pay_element_entry_values_f eev1
101: , pay_input_values_f piv3
102: , pay_element_entry_values_f eev3
103: , pay_input_values_f piv4
104: , pay_element_entry_values_f eev4
105: , pay_input_values_f piv5
106: , pay_element_entry_values_f eev5

Line 104: , pay_element_entry_values_f eev4

100: , pay_element_entry_values_f eev1
101: , pay_input_values_f piv3
102: , pay_element_entry_values_f eev3
103: , pay_input_values_f piv4
104: , pay_element_entry_values_f eev4
105: , pay_input_values_f piv5
106: , pay_element_entry_values_f eev5
107: , pay_input_values_f piv6
108: , pay_element_entry_values_f eev6

Line 106: , pay_element_entry_values_f eev5

102: , pay_element_entry_values_f eev3
103: , pay_input_values_f piv4
104: , pay_element_entry_values_f eev4
105: , pay_input_values_f piv5
106: , pay_element_entry_values_f eev5
107: , pay_input_values_f piv6
108: , pay_element_entry_values_f eev6
109: , pay_input_values_f piv8
110: , pay_element_entry_values_f eev8

Line 108: , pay_element_entry_values_f eev6

104: , pay_element_entry_values_f eev4
105: , pay_input_values_f piv5
106: , pay_element_entry_values_f eev5
107: , pay_input_values_f piv6
108: , pay_element_entry_values_f eev6
109: , pay_input_values_f piv8
110: , pay_element_entry_values_f eev8
111: , pay_input_values_f piv13
112: , pay_element_entry_values_f eev13

Line 110: , pay_element_entry_values_f eev8

106: , pay_element_entry_values_f eev5
107: , pay_input_values_f piv6
108: , pay_element_entry_values_f eev6
109: , pay_input_values_f piv8
110: , pay_element_entry_values_f eev8
111: , pay_input_values_f piv13
112: , pay_element_entry_values_f eev13
113: , hr_lookups hrl0
114: , hr_lookups hrl1

Line 112: , pay_element_entry_values_f eev13

108: , pay_element_entry_values_f eev6
109: , pay_input_values_f piv8
110: , pay_element_entry_values_f eev8
111: , pay_input_values_f piv13
112: , pay_element_entry_values_f eev13
113: , hr_lookups hrl0
114: , hr_lookups hrl1
115: , hr_lookups hrl3
116: , hr_lookups hrl4

Line 247: pay_element_entry_values_f pev,

243: SELECT pee.assignment_id
244: ,pev.screen_entry_value tfn_for_super_flag
245: FROM per_assignments_f paa,
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

Line 275: FROM pay_element_entry_values_f pev1

271: FROM per_assignments_f a
272: WHERE a.assignment_id = paa.assignment_id
273: )
274: AND pev.effective_start_date = (SELECT max(pev1.effective_start_date)
275: FROM pay_element_entry_values_f pev1
276: WHERE pev1.element_entry_value_id = pev.element_entry_value_id
277: AND pev1.effective_start_date <= c_report_end_date
278: )
279: AND c_report_end_date BETWEEN pet.effective_start_date AND pet.effective_end_date