APPS.PAY_IN_UTILS dependencies on PAY_ELEMENT_TYPES_F

Line 1186: FROM pay_element_types_f

1182: IS
1183: CURSOR csr_element_type_id
1184: IS
1185: SELECT element_type_id
1186: FROM pay_element_types_f
1187: WHERE (legislation_code = 'IN' OR business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
1188: AND element_name = p_element_name
1189: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1190:

Line 1197: , pay_element_types_f types

1193: IS
1194: SELECT link.element_link_id
1195: FROM per_assignments_f assgn
1196: , pay_element_links_f link
1197: , pay_element_types_f types
1198: WHERE assgn.assignment_id = p_assignment_id
1199: AND ((link.payroll_id IS NOT NULL AND link.payroll_id = assgn.payroll_id) OR
1200: (link.link_to_all_payrolls_flag = 'Y' AND assgn.payroll_id IS NOT NULL) OR
1201: (link.payroll_id IS NULL AND link.link_to_all_payrolls_flag = 'N'))

Line 1227: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1223: AND p_effective_date BETWEEN types.effective_start_date
1224: AND types.effective_end_date;
1225: */
1226: p_message VARCHAR2(30);
1227: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1228:
1229: BEGIN
1230: p_message :='SUCCESS';
1231: /*

Line 1491: FROM pay_element_types_f

1487: set_location(g_debug, 'Entering: '||l_procedure,10);
1488:
1489: SELECT element_type_id
1490: INTO l_element_id
1491: FROM pay_element_types_f
1492: WHERE element_name = p_element_name
1493: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1494:
1495: trace('Element Type Id',l_element_id);

Line 1751: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1747:
1748: c_end_of_time CONSTANT DATE := TO_DATE('31/12/4712','DD/MM/YYYY');
1749: v_form_res_rule_id NUMBER;
1750: l_input_value_id pay_formula_result_rules_f.input_value_id%TYPE;
1751: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1752: l_procedure CONSTANT VARCHAR2(100):= g_package||'ins_form_res_rule';
1753: l_message VARCHAR2(1000);
1754:
1755: BEGIN

Line 2272: FROM pay_element_types_f

2268: RETURN VARCHAR IS
2269:
2270: CURSOR c_processing_type IS
2271: SELECT processing_type
2272: FROM pay_element_types_f
2273: WHERE element_type_id = p_element_type_id
2274: AND business_group_id = p_business_group_id
2275: AND p_earned_date BETWEEN effective_start_date AND effective_end_date;
2276:

Line 2419: FROM pay_element_types_f pee

2415: IS
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')