DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on HR_LOOKUPS

Line 113: , hr_lookups hrl0

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
117: , hr_lookups hrl5

Line 114: , hr_lookups hrl1

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
117: , hr_lookups hrl5
118: , hr_lookups hrl8

Line 115: , hr_lookups hrl3

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
117: , hr_lookups hrl5
118: , hr_lookups hrl8
119: WHERE pap.business_group_id=c_business_group_id

Line 116: , hr_lookups hrl4

112: , pay_element_entry_values_f eev13
113: , hr_lookups hrl0
114: , hr_lookups hrl1
115: , hr_lookups hrl3
116: , hr_lookups hrl4
117: , hr_lookups hrl5
118: , hr_lookups hrl8
119: WHERE pap.business_group_id=c_business_group_id
120: and paa.business_group_id = pap.business_group_id

Line 117: , hr_lookups hrl5

113: , hr_lookups hrl0
114: , hr_lookups hrl1
115: , hr_lookups hrl3
116: , hr_lookups hrl4
117: , hr_lookups hrl5
118: , hr_lookups hrl8
119: WHERE pap.business_group_id=c_business_group_id
120: and paa.business_group_id = pap.business_group_id
121: and pap.person_id=paa.person_id

Line 118: , hr_lookups hrl8

114: , hr_lookups hrl1
115: , hr_lookups hrl3
116: , hr_lookups hrl4
117: , hr_lookups hrl5
118: , hr_lookups hrl8
119: WHERE pap.business_group_id=c_business_group_id
120: and paa.business_group_id = pap.business_group_id
121: and pap.person_id=paa.person_id
122: and pps.person_id=paa.person_id

Line 249: hr_lookups hrl0

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
253: AND pev.element_entry_id = pee.element_entry_id