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 564: ,pay_element_types_f et

560: FROM pay_run_results rr
561: ,pay_run_result_values rrv
562: ,pay_input_values_f iv
563: ,pay_input_values_f_tl ivt
564: ,pay_element_types_f et
565: ,pay_element_types_f_tl ettl
566: WHERE rr.element_type_id = et.element_type_id
567: AND iv.input_value_id = rrv.input_value_id
568: AND iv.name = 'Loan Type'

Line 565: ,pay_element_types_f_tl ettl

561: ,pay_run_result_values rrv
562: ,pay_input_values_f iv
563: ,pay_input_values_f_tl ivt
564: ,pay_element_types_f et
565: ,pay_element_types_f_tl ettl
566: WHERE rr.element_type_id = et.element_type_id
567: AND iv.input_value_id = rrv.input_value_id
568: AND iv.name = 'Loan Type'
569: AND iv.legislation_code = 'AE'

Line 613: , pay_element_types_f et

609: , pay_run_results rr
610: , pay_run_result_values rrv
611: , pay_input_values_f iv
612: , pay_input_values_f_tl ivtl
613: , pay_element_types_f et
614: , pay_element_types_f_tl ettl
615: --, pay_element_set_members esm
616: --, pay_element_sets es
617: where aa.assignment_action_id :action_clause

Line 614: , pay_element_types_f_tl ettl

610: , pay_run_result_values rrv
611: , pay_input_values_f iv
612: , pay_input_values_f_tl ivtl
613: , pay_element_types_f et
614: , pay_element_types_f_tl ettl
615: --, pay_element_set_members esm
616: --, pay_element_sets es
617: where aa.assignment_action_id :action_clause
618: and aa.assignment_action_id = rr.assignment_action_id