APPS.PAY_AE_SOE dependencies on PAY_ELEMENT_TYPES_F

Line 237: FROM pay_element_types_f

233:
234: --
235: cursor getSIele IS
236: SELECT element_type_id
237: FROM pay_element_types_f
238: WHERE element_name = 'Social Insurance'
239: and legislation_code = 'AE';
240: --
241: cursor getRRstatus(l_ele_id number) IS

Line 558: ,pay_element_types_f et

554: FROM pay_run_results rr
555: ,pay_run_result_values rrv
556: ,pay_input_values_f iv
557: ,pay_input_values_f_tl ivt
558: ,pay_element_types_f et
559: ,pay_element_types_f_tl ettl
560: WHERE rr.element_type_id = et.element_type_id
561: AND iv.input_value_id = rrv.input_value_id
562: AND iv.name = 'Loan Type'

Line 559: ,pay_element_types_f_tl ettl

555: ,pay_run_result_values rrv
556: ,pay_input_values_f iv
557: ,pay_input_values_f_tl ivt
558: ,pay_element_types_f et
559: ,pay_element_types_f_tl ettl
560: WHERE rr.element_type_id = et.element_type_id
561: AND iv.input_value_id = rrv.input_value_id
562: AND iv.name = 'Loan Type'
563: AND iv.legislation_code = 'AE'

Line 607: , pay_element_types_f et

603: , pay_run_results rr
604: , pay_run_result_values rrv
605: , pay_input_values_f iv
606: , pay_input_values_f_tl ivtl
607: , pay_element_types_f et
608: , pay_element_types_f_tl ettl
609: , pay_element_set_members esm
610: , pay_element_sets es
611: where aa.assignment_action_id :action_clause

Line 608: , pay_element_types_f_tl ettl

604: , pay_run_result_values rrv
605: , pay_input_values_f iv
606: , pay_input_values_f_tl ivtl
607: , pay_element_types_f et
608: , pay_element_types_f_tl ettl
609: , pay_element_set_members esm
610: , pay_element_sets es
611: where aa.assignment_action_id :action_clause
612: and aa.assignment_action_id = rr.assignment_action_id