DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on PAY_INPUT_VALUES_F

Line 1446: FROM pay_input_values_f IPV,

1442:
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

Line 1480: FROM pay_input_values_f IPV,

1476: hr_utility.trace('In RATE CODE');
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

Line 1515: FROM pay_input_values_f IPV,

1511: hr_utility.trace('in MONTHLY SALARY');
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

Line 2660: , pay_input_values_f INPUTV

2656: , INPUTV.input_value_id
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