APPS.PAY_IN_UTILS dependencies on PAY_ELEMENT_TEMPLATES

Line 1692: FROM pay_element_templates

1688: set_location(g_debug,'Entering: '||l_procedure,10);
1689:
1690: SELECT template_id
1691: INTO l_template_id
1692: FROM pay_element_templates
1693: WHERE template_name = p_template_name
1694: AND legislation_code = 'IN';
1695:
1696: trace('Template Id',l_template_id);

Line 2420: ,pay_element_templates pet

2416: CURSOR c_config_info
2417: IS
2418: SELECT pet.configuration_information2
2419: FROM pay_element_types_f pee
2420: ,pay_element_templates pet
2421: ,pay_shadow_element_types pset
2422: WHERE pee.element_type_id = p_element_type_id
2423: AND pee.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2424: AND pee.element_name = pset.element_name

Line 2428: l_config_info pay_element_templates.configuration_information2%TYPE;

2424: AND pee.element_name = pset.element_name
2425: AND pset.template_id = pet.template_id
2426: AND p_date_earned BETWEEN pee.effective_start_date AND pee.effective_end_date;
2427:
2428: l_config_info pay_element_templates.configuration_information2%TYPE;
2429:
2430: BEGIN
2431: OPEN c_config_info;
2432: FETCH c_config_info INTO l_config_info;