APPS.HR_NZ_HOLIDAYS dependencies on PAY_INPUT_VALUES_F

Line 1108: pay_input_values_f piv,

1104: ,c_assignment_id NUMBER) IS
1105: SELECT NVL(TO_DATE(pev.screen_entry_value,'YYYY/MM/DD HH24:MI:SS'),pps.date_start)
1106: FROM pay_element_entries_f pee,
1107: pay_element_entry_values_f pev,
1108: pay_input_values_f piv,
1109: pay_accrual_plans pap,
1110: per_all_assignments_f asg,
1111: per_periods_of_service pps
1112: WHERE pev.element_entry_id = pee.element_entry_id

Line 1504: CURSOR csr_accrual_record_iv(c_element_type_id pay_input_values_f.element_type_id%TYPE

1500: FROM pay_element_types_f pet
1501: WHERE pet.element_name = 'Annual Leave Accrual Record'
1502: AND c_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
1503:
1504: CURSOR csr_accrual_record_iv(c_element_type_id pay_input_values_f.element_type_id%TYPE
1505: ,c_effective_date DATE) IS
1506: SELECT piv.input_value_id
1507: ,piv.name
1508: FROM pay_input_values_f piv

Line 1508: FROM pay_input_values_f piv

1504: CURSOR csr_accrual_record_iv(c_element_type_id pay_input_values_f.element_type_id%TYPE
1505: ,c_effective_date DATE) IS
1506: SELECT piv.input_value_id
1507: ,piv.name
1508: FROM pay_input_values_f piv
1509: WHERE piv.element_type_id = c_element_type_id
1510: AND c_effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
1511:
1512: l_proc VARCHAR2(72) := g_package||'get_ar_element_details';

Line 2112: , pay_input_values_f iv2 -- Pay Value input value

2108: , per_time_periods tp
2109: , pay_run_results rr2 -- run result for Annual -- Leave Pay element type
2110: , pay_run_result_values rrv2 -- run result value for -- Annual Leave Pay element -- pay value ,
2111: , pay_element_types_f et2 -- Annual Leave Pay element
2112: , pay_input_values_f iv2 -- Pay Value input value
2113: where ap.accrual_plan_id = p_accrual_plan_id
2114: and eev.input_value_id = ap.pto_input_value_id
2115: and ee.element_entry_id = eev.element_entry_id
2116: and ee.assignment_id = p_assignment_id

Line 3509: , pay_input_values_f piv

3505: CURSOR c_act_ann_pay(p_assignment_id number, p_element_entry_id number, p_assgt_action_id number,p_effective_date date) IS
3506: select prv.result_value
3507: from pay_run_result_values prv
3508: , pay_run_results prr
3509: , pay_input_values_f piv
3510: , pay_element_types_f pet
3511: , pay_element_entries_f pee
3512: where pet.element_name = 'Annual Leave Pay'
3513: and pet.legislation_code = 'NZ'

Line 3755: ,pay_input_values_f piv1

3751: from
3752: pay_accrual_plans pap
3753: ,pay_element_types_f pet
3754: ,pay_element_links_f pel
3755: ,pay_input_values_f piv1
3756: ,pay_input_values_f piv2
3757: ,pay_element_entries_f pee
3758: ,pay_element_entry_values_f pev1
3759: ,pay_element_entry_values_f pev2

Line 3756: ,pay_input_values_f piv2

3752: pay_accrual_plans pap
3753: ,pay_element_types_f pet
3754: ,pay_element_links_f pel
3755: ,pay_input_values_f piv1
3756: ,pay_input_values_f piv2
3757: ,pay_element_entries_f pee
3758: ,pay_element_entry_values_f pev1
3759: ,pay_element_entry_values_f pev2
3760: where