APPS.PAY_KW_SOE dependencies on PAY_ELEMENT_TYPES_F

Line 231: FROM pay_element_types_f

227: AND ORGANIZATION_ID = l_business_group_id;
228: --
229: cursor getSIele IS
230: SELECT element_type_id
231: FROM pay_element_types_f
232: WHERE element_name = 'Social Insurance'
233: and legislation_code = 'KW';
234: --
235: cursor getRRstatus(l_ele_id number) IS

Line 548: ,pay_element_types_f et

544: FROM pay_run_results rr
545: ,pay_run_result_values rrv
546: ,pay_input_values_f iv
547: ,pay_input_values_f_tl ivt
548: ,pay_element_types_f et
549: ,pay_element_types_f_tl ettl
550: WHERE rr.element_type_id = et.element_type_id
551: AND iv.input_value_id = rrv.input_value_id
552: AND iv.name = 'Loan Type'

Line 549: ,pay_element_types_f_tl ettl

545: ,pay_run_result_values rrv
546: ,pay_input_values_f iv
547: ,pay_input_values_f_tl ivt
548: ,pay_element_types_f et
549: ,pay_element_types_f_tl ettl
550: WHERE rr.element_type_id = et.element_type_id
551: AND iv.input_value_id = rrv.input_value_id
552: AND iv.name = 'Loan Type'
553: AND iv.legislation_code = 'KW'

Line 597: , pay_element_types_f et

593: , pay_run_results rr
594: , pay_run_result_values rrv
595: , pay_input_values_f iv
596: , pay_input_values_f_tl ivtl
597: , pay_element_types_f et
598: , pay_element_types_f_tl ettl
599: , pay_element_set_members esm
600: , pay_element_sets es
601: where aa.assignment_action_id :action_clause

Line 598: , pay_element_types_f_tl ettl

594: , pay_run_result_values rrv
595: , pay_input_values_f iv
596: , pay_input_values_f_tl ivtl
597: , pay_element_types_f et
598: , pay_element_types_f_tl ettl
599: , pay_element_set_members esm
600: , pay_element_sets es
601: where aa.assignment_action_id :action_clause
602: and aa.assignment_action_id = rr.assignment_action_id