APPS.PAY_CA_USER_INIT_DEDN dependencies on PAY_ELEMENT_TEMPLATES

Line 255: from pay_element_templates

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

Line 768: from pay_element_templates

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

Line 1271: from pay_element_templates

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

Line 1335: from pay_element_templates

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