APPS.PAY_IN_UTILS dependencies on PAY_ELEMENT_TEMPLATES

Line 1677: FROM pay_element_templates

1673: set_location(g_debug,'Entering: '||l_procedure,10);
1674:
1675: SELECT template_id
1676: INTO l_template_id
1677: FROM pay_element_templates
1678: WHERE template_name = p_template_name
1679: AND legislation_code = 'IN';
1680:
1681: trace('Template Id',l_template_id);

Line 2405: ,pay_element_templates pet

2401: CURSOR c_config_info
2402: IS
2403: SELECT pet.configuration_information2
2404: FROM pay_element_types_f pee
2405: ,pay_element_templates pet
2406: ,pay_shadow_element_types pset
2407: WHERE pee.element_type_id = p_element_type_id
2408: AND pee.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2409: AND pee.element_name = pset.element_name

Line 2413: l_config_info pay_element_templates.configuration_information2%TYPE;

2409: AND pee.element_name = pset.element_name
2410: AND pset.template_id = pet.template_id
2411: AND p_date_earned BETWEEN pee.effective_start_date AND pee.effective_end_date;
2412:
2413: l_config_info pay_element_templates.configuration_information2%TYPE;
2414:
2415: BEGIN
2416: OPEN c_config_info;
2417: FETCH c_config_info INTO l_config_info;