APPS.PAY_FR_PTO_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1438: ,pay_element_types_f petf

1434: select sum(nvl(prrv_pay.result_value,0)) payments
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

Line 1646: ,pay_element_types_f petf

1642: select sum(nvl(prrv_pay.result_value,0)) payments
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

Line 1925: from pay_element_types_f pet

1921: l_unused number;
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'

Line 2043: from pay_element_types_f pet

2039: l_unused number;
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'

Line 4327: from pay_element_types_f pet

4323: select piv1.input_value_id
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

Line 5748: ,pay_element_types_f pet

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'
5752: and pet.legislation_code = 'FR'