APPS.PAY_CA_USER_INIT_DEDN dependencies on PAY_ELEMENT_TEMPLATES

Line 252: from pay_element_templates

248: 'Legislation is :'||p_legislation_code);
249: --
250: select template_id
251: into l_template_id
252: from pay_element_templates
253: where template_name = l_template_name
254: and legislation_code = p_legislation_code
255: and business_group_id is NULL
256: and template_type = 'T';

Line 765: from pay_element_templates

761: 'Legislation is :'||p_legislation_code);
762: --
763: select template_id
764: into l_template_id
765: from pay_element_templates
766: where template_name = l_template_name
767: and legislation_code = p_legislation_code
768: and business_group_id is NULL
769: and template_type = 'T';

Line 1268: from pay_element_templates

1264: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',1);
1265: --
1266: select template_id
1267: into l_template_id
1268: from pay_element_templates
1269: where base_name = p_ele_name
1270: and business_group_id = p_business_group_id
1271: and template_type = 'U';
1272: --

Line 1332: from pay_element_templates

1328: hr_utility.set_location('pay_ca_user_init_garn.delete_user_init_garnishment',1);
1329: --
1330: select template_id
1331: into l_template_id
1332: from pay_element_templates
1333: where base_name = p_ele_name
1334: and business_group_id = p_business_group_id
1335: and template_type = 'U';
1336: --