DBA Data[Home] [Help]

APPS.PAY_MX_CURRENCY_CONVERSION dependencies on PAY_ELEMENT_TEMPLATES

Line 73: FROM pay_element_templates

69: AND pgi.run_payroll_action_id = ppa.payroll_action_id;
70:
71: CURSOR c_legi_ele_tmplt IS
72: SELECT template_id
73: FROM pay_element_templates
74: WHERE legislation_code = 'MX';
75:
76: CURSOR c_bg_ele_tmplt( cp_business_group_id NUMBER ) IS
77: SELECT template_id

Line 78: FROM pay_element_templates

74: WHERE legislation_code = 'MX';
75:
76: CURSOR c_bg_ele_tmplt( cp_business_group_id NUMBER ) IS
77: SELECT template_id
78: FROM pay_element_templates
79: WHERE business_group_id = cp_business_group_id;
80:
81: CURSOR c_ben_chc_popl( cp_business_group_id NUMBER ) IS
82: SELECT rowid