DBA Data[Home] [Help]

APPS.PAY_SA_UPGRADE dependencies on PAY_INPUT_VALUES_F

Line 65: ,pay_input_values_f iv

61: ,aa.assignment_action_id
62: ,aa.assignment_id
63: ,DECODE(et.element_name, 'GOSI', rr.element_entry_id, rr.source_id) element_entry_id
64: FROM pay_element_types_f et
65: ,pay_input_values_f iv
66: ,pay_run_results rr
67: ,pay_assignment_actions aa
68: WHERE et.element_name IN ('Employer GOSI Hazards'
69: ,'GOSI'

Line 210: FROM pay_input_values_f iv

206: ,iv.input_value_id
207: ,DECODE(iv.name, 'Joiner' , l_joiner
208: , 'Leaver' , l_leaver
209: , 'Nationality', l_nationality)
210: FROM pay_input_values_f iv
211: WHERE iv.element_type_id = l_result_rec.element_type_id
212: AND iv.name IN ('Joiner', 'Leaver', 'Nationality');
213: END LOOP;
214: --