APPS.PAY_CORE_FF_UDFS dependencies on PAY_ELEMENT_TYPES_F

Line 1441: the date join for pay_element_types_f */

1437:
1438: hr_utility.trace(' p_pay_basis IS NULL');
1439: hr_utility.trace('In p_inpval_name = RATE');
1440: /* Changed the element_name and name to init case and added
1441: the date join for pay_element_types_f */
1442:
1443: begin
1444: SELECT IPV.input_value_id
1445: INTO v_inpval_id

Line 1447: pay_element_types_f ELT

1443: begin
1444: SELECT IPV.input_value_id
1445: INTO v_inpval_id
1446: FROM pay_input_values_f IPV,
1447: pay_element_types_f ELT
1448: WHERE ELT.element_name = 'Regular Wages'
1449: and p_period_start BETWEEN ELT.effective_start_date
1450: AND ELT.effective_end_date
1451: and ELT.element_type_id = IPV.element_type_id

Line 1473: the date join for pay_element_types_f */

1469: end;
1470: --
1471: ELSIF UPPER(p_inpval_name) = 'RATE CODE' THEN
1472: /* Changed the element_name and name to init case and added
1473: the date join for pay_element_types_f */
1474:
1475: begin
1476: hr_utility.trace('In RATE CODE');
1477:

Line 1481: pay_element_types_f ELT

1477:
1478: SELECT IPV.input_value_id
1479: INTO v_inpval_id
1480: FROM pay_input_values_f IPV,
1481: pay_element_types_f ELT
1482: WHERE ELT.element_name = 'Regular Wages'
1483: and p_period_start BETWEEN ELT.effective_start_date
1484: AND ELT.effective_end_date
1485: and ELT.element_type_id = IPV.element_type_id

Line 1508: the date join for pay_element_types_f */

1504: --
1505: ELSIF UPPER(p_inpval_name) = 'MONTHLY SALARY' THEN
1506:
1507: /* Changed the element_name and name to init case and added
1508: the date join for pay_element_types_f */
1509:
1510: begin
1511: hr_utility.trace('in MONTHLY SALARY');
1512:

Line 1516: pay_element_types_f ELT

1512:
1513: SELECT IPV.input_value_id
1514: INTO v_inpval_id
1515: FROM pay_input_values_f IPV,
1516: pay_element_types_f ELT
1517: WHERE ELT.element_name = 'Regular Salary'
1518: and p_period_start BETWEEN ELT.effective_start_date
1519: AND ELT.effective_end_date
1520: and ELT.element_type_id = IPV.element_type_id

Line 2661: , pay_element_types_f ETYPE

2657: from
2658: per_all_assignments_f ASSIGN
2659: , per_pay_bases BASES
2660: , pay_input_values_f INPUTV
2661: , pay_element_types_f ETYPE
2662: , pay_rates RATE
2663: where l_date_earned BETWEEN ASSIGN.effective_start_date
2664: AND ASSIGN.effective_end_date
2665: and ASSIGN.assignment_id = l_assignment_id