APPS.PAY_FR_PTO_PKG dependencies on PAY_INPUT_VALUES_F

Line 1439: ,pay_input_values_f pivf_pay

1435: from pay_run_result_values prrv_pay
1436: ,pay_run_result_values prrv_accrual
1437: ,pay_run_result_values prrv_plan
1438: ,pay_element_types_f petf
1439: ,pay_input_values_f pivf_pay
1440: ,pay_input_values_f pivf_accrual
1441: ,pay_input_values_f pivf_plan
1442: ,pay_run_results prr
1443: ,pay_assignment_actions paa

Line 1440: ,pay_input_values_f pivf_accrual

1436: ,pay_run_result_values prrv_accrual
1437: ,pay_run_result_values prrv_plan
1438: ,pay_element_types_f petf
1439: ,pay_input_values_f pivf_pay
1440: ,pay_input_values_f pivf_accrual
1441: ,pay_input_values_f pivf_plan
1442: ,pay_run_results prr
1443: ,pay_assignment_actions paa
1444: where prrv_pay.run_result_id = prr.run_result_id

Line 1441: ,pay_input_values_f pivf_plan

1437: ,pay_run_result_values prrv_plan
1438: ,pay_element_types_f petf
1439: ,pay_input_values_f pivf_pay
1440: ,pay_input_values_f pivf_accrual
1441: ,pay_input_values_f pivf_plan
1442: ,pay_run_results prr
1443: ,pay_assignment_actions paa
1444: where prrv_pay.run_result_id = prr.run_result_id
1445: and prrv_plan.run_result_id = prr.run_result_id

Line 1647: ,pay_input_values_f pivf_pay

1643: from pay_run_result_values prrv_pay
1644: ,pay_run_result_values prrv_accrual
1645: ,pay_run_result_values prrv_plan
1646: ,pay_element_types_f petf
1647: ,pay_input_values_f pivf_pay
1648: ,pay_input_values_f pivf_accrual
1649: ,pay_input_values_f pivf_plan
1650: ,pay_run_results prr
1651: ,pay_assignment_actions paa

Line 1648: ,pay_input_values_f pivf_accrual

1644: ,pay_run_result_values prrv_accrual
1645: ,pay_run_result_values prrv_plan
1646: ,pay_element_types_f petf
1647: ,pay_input_values_f pivf_pay
1648: ,pay_input_values_f pivf_accrual
1649: ,pay_input_values_f pivf_plan
1650: ,pay_run_results prr
1651: ,pay_assignment_actions paa
1652: where prrv_pay.run_result_id = prr.run_result_id

Line 1649: ,pay_input_values_f pivf_plan

1645: ,pay_run_result_values prrv_plan
1646: ,pay_element_types_f petf
1647: ,pay_input_values_f pivf_pay
1648: ,pay_input_values_f pivf_accrual
1649: ,pay_input_values_f pivf_plan
1650: ,pay_run_results prr
1651: ,pay_assignment_actions paa
1652: where prrv_pay.run_result_id = prr.run_result_id
1653: and prrv_plan.run_result_id = prr.run_result_id

Line 1926: ,pay_input_values_f piv

1922: --
1923: CURSOR csr_input_values (p_input_name in varchar2, p_element_name in varchar2) is
1924: select piv.input_value_id, pet.element_type_id
1925: from pay_element_types_f pet
1926: ,pay_input_values_f piv
1927: where piv.element_Type_id = pet.element_type_id
1928: and pet.legislation_code = 'FR'
1929: -- and piv.legislation_code = 'FR'
1930: and pet.element_name = p_element_name

Line 2044: ,pay_input_values_f piv

2040: --
2041: CURSOR csr_input_values (p_input_name in varchar2, p_element_name in varchar2) is
2042: select piv.input_value_id, pet.element_type_id
2043: from pay_element_types_f pet
2044: ,pay_input_values_f piv
2045: where piv.element_Type_id = pet.element_type_id
2046: and pet.legislation_code = 'FR'
2047: -- and piv.legislation_code = 'FR'
2048: and pet.element_name = p_element_name

Line 2832: from pay_input_values_f piv1

2828: l_fr_plan_info g_fr_plan_info;
2829:
2830: CURSOR csr_plan_input (p_element_type_id in number) is
2831: select piv1.input_value_id acp_plan_id
2832: from pay_input_values_f piv1
2833: where piv1.element_type_id = p_element_type_id
2834: and piv1.display_sequence = 10;
2835:
2836: CURSOR csr_reference_inputs (p_ent_accrual_date_iv in number) is

Line 2839: from pay_input_values_f piv1

2835:
2836: CURSOR csr_reference_inputs (p_ent_accrual_date_iv in number) is
2837: select piv1.input_value_id reference_salary
2838: ,piv2.input_value_id reference_days
2839: from pay_input_values_f piv1
2840: ,pay_input_values_f piv2
2841: ,pay_input_values_f piv
2842: where piv1.element_type_id = piv2.element_type_id
2843: and piv1.element_type_id = piv.element_type_id

Line 2840: ,pay_input_values_f piv2

2836: CURSOR csr_reference_inputs (p_ent_accrual_date_iv in number) is
2837: select piv1.input_value_id reference_salary
2838: ,piv2.input_value_id reference_days
2839: from pay_input_values_f piv1
2840: ,pay_input_values_f piv2
2841: ,pay_input_values_f piv
2842: where piv1.element_type_id = piv2.element_type_id
2843: and piv1.element_type_id = piv.element_type_id
2844: and piv.input_value_id = p_ent_accrual_date_iv

Line 2841: ,pay_input_values_f piv

2837: select piv1.input_value_id reference_salary
2838: ,piv2.input_value_id reference_days
2839: from pay_input_values_f piv1
2840: ,pay_input_values_f piv2
2841: ,pay_input_values_f piv
2842: where piv1.element_type_id = piv2.element_type_id
2843: and piv1.element_type_id = piv.element_type_id
2844: and piv.input_value_id = p_ent_accrual_date_iv
2845: and piv1.display_sequence = 80

Line 2890: ,pay_input_values_f piv

2886: ,pivT.element_type_id TERM_element_id
2887: --
2888: ,pap.business_group_id business_Group_id
2889: from pay_accrual_plans pap
2890: ,pay_input_values_f piv
2891: ,pay_input_values_f pivE
2892: ,pay_input_values_f pivO
2893: ,pay_input_values_f pivA
2894: -- added for termination processing

Line 2891: ,pay_input_values_f pivE

2887: --
2888: ,pap.business_group_id business_Group_id
2889: from pay_accrual_plans pap
2890: ,pay_input_values_f piv
2891: ,pay_input_values_f pivE
2892: ,pay_input_values_f pivO
2893: ,pay_input_values_f pivA
2894: -- added for termination processing
2895: ,pay_input_values_f pivT

Line 2892: ,pay_input_values_f pivO

2888: ,pap.business_group_id business_Group_id
2889: from pay_accrual_plans pap
2890: ,pay_input_values_f piv
2891: ,pay_input_values_f pivE
2892: ,pay_input_values_f pivO
2893: ,pay_input_values_f pivA
2894: -- added for termination processing
2895: ,pay_input_values_f pivT
2896: where pap.accrual_plan_id = p_accrual_plan_id

Line 2893: ,pay_input_values_f pivA

2889: from pay_accrual_plans pap
2890: ,pay_input_values_f piv
2891: ,pay_input_values_f pivE
2892: ,pay_input_values_f pivO
2893: ,pay_input_values_f pivA
2894: -- added for termination processing
2895: ,pay_input_values_f pivT
2896: where pap.accrual_plan_id = p_accrual_plan_id
2897: and piv.input_value_id = pap.pto_input_value_id

Line 2895: ,pay_input_values_f pivT

2891: ,pay_input_values_f pivE
2892: ,pay_input_values_f pivO
2893: ,pay_input_values_f pivA
2894: -- added for termination processing
2895: ,pay_input_values_f pivT
2896: where pap.accrual_plan_id = p_accrual_plan_id
2897: and piv.input_value_id = pap.pto_input_value_id
2898: and pivE.input_value_id = pap.information8
2899: and pivO.input_value_id = pap.information13

Line 2946: ,pay_input_values_f piv

2942: from pay_accrual_plans pap
2943: ,per_absence_attendances paa
2944: ,per_absence_attendance_types pat
2945: ,pay_element_entries_f pee
2946: ,pay_input_values_f piv
2947: ,pay_input_values_f pivE
2948: ,pay_input_values_f pivO
2949: ,pay_input_values_f pivA
2950: ,pay_input_values_f pivT

Line 2947: ,pay_input_values_f pivE

2943: ,per_absence_attendances paa
2944: ,per_absence_attendance_types pat
2945: ,pay_element_entries_f pee
2946: ,pay_input_values_f piv
2947: ,pay_input_values_f pivE
2948: ,pay_input_values_f pivO
2949: ,pay_input_values_f pivA
2950: ,pay_input_values_f pivT
2951: where paa.absence_attendance_type_id = pat.absence_attendance_type_id

Line 2948: ,pay_input_values_f pivO

2944: ,per_absence_attendance_types pat
2945: ,pay_element_entries_f pee
2946: ,pay_input_values_f piv
2947: ,pay_input_values_f pivE
2948: ,pay_input_values_f pivO
2949: ,pay_input_values_f pivA
2950: ,pay_input_values_f pivT
2951: where paa.absence_attendance_type_id = pat.absence_attendance_type_id
2952: and pivE.input_value_id = pap.information8

Line 2949: ,pay_input_values_f pivA

2945: ,pay_element_entries_f pee
2946: ,pay_input_values_f piv
2947: ,pay_input_values_f pivE
2948: ,pay_input_values_f pivO
2949: ,pay_input_values_f pivA
2950: ,pay_input_values_f pivT
2951: where paa.absence_attendance_type_id = pat.absence_attendance_type_id
2952: and pivE.input_value_id = pap.information8
2953: and pivO.input_value_id = pap.information13

Line 2950: ,pay_input_values_f pivT

2946: ,pay_input_values_f piv
2947: ,pay_input_values_f pivE
2948: ,pay_input_values_f pivO
2949: ,pay_input_values_f pivA
2950: ,pay_input_values_f pivT
2951: where paa.absence_attendance_type_id = pat.absence_attendance_type_id
2952: and pivE.input_value_id = pap.information8
2953: and pivO.input_value_id = pap.information13
2954: and pivA.input_value_id = pap.information18

Line 2965: from pay_input_values_f piv

2961:
2962: -- the ddf stores BASE input value id - but the RATE is needed
2963: CURSOR csr_temp_swap_rate (p_element_type_id in number) is
2964: select piv.input_value_id input_value_id
2965: from pay_input_values_f piv
2966: where piv.element_type_id = p_element_type_id
2967: and piv.display_sequence = 40;
2968:
2969: rec_plan_info csr_plan_info%ROWTYPE;

Line 4328: ,pay_input_values_f piv1

4324: ,piv2.input_value_id
4325: ,piv3.input_value_id
4326: ,pet.element_type_id
4327: from pay_element_types_f pet
4328: ,pay_input_values_f piv1
4329: ,pay_input_values_f piv2
4330: ,pay_input_values_f piv3
4331: where piv1.element_Type_id = pet.element_type_id
4332: and piv2.element_Type_id = pet.element_type_id

Line 4329: ,pay_input_values_f piv2

4325: ,piv3.input_value_id
4326: ,pet.element_type_id
4327: from pay_element_types_f pet
4328: ,pay_input_values_f piv1
4329: ,pay_input_values_f piv2
4330: ,pay_input_values_f piv3
4331: where piv1.element_Type_id = pet.element_type_id
4332: and piv2.element_Type_id = pet.element_type_id
4333: and piv3.element_Type_id = pet.element_type_id

Line 4330: ,pay_input_values_f piv3

4326: ,pet.element_type_id
4327: from pay_element_types_f pet
4328: ,pay_input_values_f piv1
4329: ,pay_input_values_f piv2
4330: ,pay_input_values_f piv3
4331: where piv1.element_Type_id = pet.element_type_id
4332: and piv2.element_Type_id = pet.element_type_id
4333: and piv3.element_Type_id = pet.element_type_id
4334: and pet.legislation_code = 'FR'

Line 4513: from pay_input_values_f piv1

4509:
4510:
4511: CURSOR csr_plan_input (p_element_type_id in number) is
4512: select piv1.input_value_id acp_plan_id
4513: from pay_input_values_f piv1
4514: where piv1.element_type_id = p_element_type_id
4515: and piv1.display_sequence = 10;
4516:
4517: CURSOR csr_reference_inputs (p_ent_accrual_date_iv in number) is

Line 4520: from pay_input_values_f piv1

4516:
4517: CURSOR csr_reference_inputs (p_ent_accrual_date_iv in number) is
4518: select piv1.input_value_id reference_salary
4519: ,piv2.input_value_id reference_days
4520: from pay_input_values_f piv1
4521: ,pay_input_values_f piv2
4522: ,pay_input_values_f piv
4523: where piv1.element_type_id = piv2.element_type_id
4524: and piv1.element_type_id = piv.element_type_id

Line 4521: ,pay_input_values_f piv2

4517: CURSOR csr_reference_inputs (p_ent_accrual_date_iv in number) is
4518: select piv1.input_value_id reference_salary
4519: ,piv2.input_value_id reference_days
4520: from pay_input_values_f piv1
4521: ,pay_input_values_f piv2
4522: ,pay_input_values_f piv
4523: where piv1.element_type_id = piv2.element_type_id
4524: and piv1.element_type_id = piv.element_type_id
4525: and piv.input_value_id = p_ent_accrual_date_iv

Line 4522: ,pay_input_values_f piv

4518: select piv1.input_value_id reference_salary
4519: ,piv2.input_value_id reference_days
4520: from pay_input_values_f piv1
4521: ,pay_input_values_f piv2
4522: ,pay_input_values_f piv
4523: where piv1.element_type_id = piv2.element_type_id
4524: and piv1.element_type_id = piv.element_type_id
4525: and piv.input_value_id = p_ent_accrual_date_iv
4526: and piv1.display_sequence = 80

Line 4564: ,pay_input_values_f piv

4560: ,pivO.element_type_id OBS_element_id
4561: ,pivA.element_type_id ADJ_element_id
4562: ,pap.business_group_id business_Group_id
4563: from pay_accrual_plans pap
4564: ,pay_input_values_f piv
4565: ,pay_input_values_f pivE
4566: ,pay_input_values_f pivO
4567: ,pay_input_values_f pivA
4568: where pap.accrual_plan_id = p_accrual_plan_id

Line 4565: ,pay_input_values_f pivE

4561: ,pivA.element_type_id ADJ_element_id
4562: ,pap.business_group_id business_Group_id
4563: from pay_accrual_plans pap
4564: ,pay_input_values_f piv
4565: ,pay_input_values_f pivE
4566: ,pay_input_values_f pivO
4567: ,pay_input_values_f pivA
4568: where pap.accrual_plan_id = p_accrual_plan_id
4569: and piv.input_value_id = pap.pto_input_value_id

Line 4566: ,pay_input_values_f pivO

4562: ,pap.business_group_id business_Group_id
4563: from pay_accrual_plans pap
4564: ,pay_input_values_f piv
4565: ,pay_input_values_f pivE
4566: ,pay_input_values_f pivO
4567: ,pay_input_values_f pivA
4568: where pap.accrual_plan_id = p_accrual_plan_id
4569: and piv.input_value_id = pap.pto_input_value_id
4570: and pivE.input_value_id = pap.information8

Line 4567: ,pay_input_values_f pivA

4563: from pay_accrual_plans pap
4564: ,pay_input_values_f piv
4565: ,pay_input_values_f pivE
4566: ,pay_input_values_f pivO
4567: ,pay_input_values_f pivA
4568: where pap.accrual_plan_id = p_accrual_plan_id
4569: and piv.input_value_id = pap.pto_input_value_id
4570: and pivE.input_value_id = pap.information8
4571: and pivO.input_value_id = pap.information13

Line 4613: ,pay_input_values_f piv

4609: from pay_accrual_plans pap
4610: ,per_absence_attendances paa
4611: ,per_absence_attendance_types pat
4612: ,pay_element_entries_f pee
4613: ,pay_input_values_f piv
4614: ,pay_input_values_f pivE
4615: ,pay_input_values_f pivO
4616: ,pay_input_values_f pivA
4617: where paa.absence_attendance_type_id = pat.absence_attendance_type_id

Line 4614: ,pay_input_values_f pivE

4610: ,per_absence_attendances paa
4611: ,per_absence_attendance_types pat
4612: ,pay_element_entries_f pee
4613: ,pay_input_values_f piv
4614: ,pay_input_values_f pivE
4615: ,pay_input_values_f pivO
4616: ,pay_input_values_f pivA
4617: where paa.absence_attendance_type_id = pat.absence_attendance_type_id
4618: and pivE.input_value_id = pap.information8

Line 4615: ,pay_input_values_f pivO

4611: ,per_absence_attendance_types pat
4612: ,pay_element_entries_f pee
4613: ,pay_input_values_f piv
4614: ,pay_input_values_f pivE
4615: ,pay_input_values_f pivO
4616: ,pay_input_values_f pivA
4617: where paa.absence_attendance_type_id = pat.absence_attendance_type_id
4618: and pivE.input_value_id = pap.information8
4619: and pivO.input_value_id = pap.information13

Line 4616: ,pay_input_values_f pivA

4612: ,pay_element_entries_f pee
4613: ,pay_input_values_f piv
4614: ,pay_input_values_f pivE
4615: ,pay_input_values_f pivO
4616: ,pay_input_values_f pivA
4617: where paa.absence_attendance_type_id = pat.absence_attendance_type_id
4618: and pivE.input_value_id = pap.information8
4619: and pivO.input_value_id = pap.information13
4620: and pivA.input_value_id = pap.information18

Line 5747: ,pay_input_values_f piv_ref

5743: cursor csr_find_entry is
5744: select 0, pev_def.screen_entry_value
5745: from pay_element_entries_f pee
5746: ,pay_element_entry_values_f pev_ref
5747: ,pay_input_values_f piv_ref
5748: ,pay_element_types_f pet
5749: ,pay_input_values_f piv_def
5750: ,pay_element_entry_values_f pev_def
5751: where pet.element_name = 'FR_FIXED_TERM_CONTRACT_INDEMNITY'

Line 5749: ,pay_input_values_f piv_def

5745: from pay_element_entries_f pee
5746: ,pay_element_entry_values_f pev_ref
5747: ,pay_input_values_f piv_ref
5748: ,pay_element_types_f pet
5749: ,pay_input_values_f piv_def
5750: ,pay_element_entry_values_f pev_def
5751: where pet.element_name = 'FR_FIXED_TERM_CONTRACT_INDEMNITY'
5752: and pet.legislation_code = 'FR'
5753: and pet.business_group_id is null