DBA Data[Home] [Help]

APPS.PAY_US_EARNINGS_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 118: FROM pay_element_templates

114: -- cursor to get the template id
115: --
116: CURSOR c_template(p_template_name VARCHAR2) IS
117: SELECT template_id
118: FROM pay_element_templates
119: WHERE template_name = p_template_name
120: AND legislation_code = p_legislation_code
121: AND template_type = 'T'
122: AND business_group_id IS NULL;

Line 715: FROM pay_element_templates

711: l_proc VARCHAR2(60) := 'pay_earnings_template.delete_ele_template_objects';
712: --
713: CURSOR c1 IS
714: SELECT template_id
715: FROM pay_element_templates
716: WHERE base_name = p_ele_name
717: AND business_group_id = p_business_group_id
718: AND template_type = 'U';
719: --