APPS.PAY_IN_UTILS dependencies on PAY_ELEMENT_TYPES_F

Line 1171: FROM pay_element_types_f

1167: IS
1168: CURSOR csr_element_type_id
1169: IS
1170: SELECT element_type_id
1171: FROM pay_element_types_f
1172: WHERE (legislation_code = 'IN' OR business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
1173: AND element_name = p_element_name
1174: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1175:

Line 1182: , pay_element_types_f types

1178: IS
1179: SELECT link.element_link_id
1180: FROM per_assignments_f assgn
1181: , pay_element_links_f link
1182: , pay_element_types_f types
1183: WHERE assgn.assignment_id = p_assignment_id
1184: AND ((link.payroll_id IS NOT NULL AND link.payroll_id = assgn.payroll_id) OR
1185: (link.link_to_all_payrolls_flag = 'Y' AND assgn.payroll_id IS NOT NULL) OR
1186: (link.payroll_id IS NULL AND link.link_to_all_payrolls_flag = 'N'))

Line 1212: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1208: AND p_effective_date BETWEEN types.effective_start_date
1209: AND types.effective_end_date;
1210: */
1211: p_message VARCHAR2(30);
1212: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1213:
1214: BEGIN
1215: p_message :='SUCCESS';
1216: /*

Line 1476: FROM pay_element_types_f

1472: set_location(g_debug, 'Entering: '||l_procedure,10);
1473:
1474: SELECT element_type_id
1475: INTO l_element_id
1476: FROM pay_element_types_f
1477: WHERE element_name = p_element_name
1478: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1479:
1480: trace('Element Type Id',l_element_id);

Line 1736: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1732:
1733: c_end_of_time CONSTANT DATE := TO_DATE('31/12/4712','DD/MM/YYYY');
1734: v_form_res_rule_id NUMBER;
1735: l_input_value_id pay_formula_result_rules_f.input_value_id%TYPE;
1736: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1737: l_procedure CONSTANT VARCHAR2(100):= g_package||'ins_form_res_rule';
1738: l_message VARCHAR2(1000);
1739:
1740: BEGIN

Line 2257: FROM pay_element_types_f

2253: RETURN VARCHAR IS
2254:
2255: CURSOR c_processing_type IS
2256: SELECT processing_type
2257: FROM pay_element_types_f
2258: WHERE element_type_id = p_element_type_id
2259: AND business_group_id = p_business_group_id
2260: AND p_earned_date BETWEEN effective_start_date AND effective_end_date;
2261:

Line 2404: FROM pay_element_types_f pee

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