APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_INPUT_VALUES_F

Line 898: ,pay_input_values_f piv

894: ) is
895: select pet.element_type_id element_type_id
896: ,piv.input_value_id input_value_id --Vibhor : PTS
897: from pay_element_types_f pet
898: ,pay_input_values_f piv
899: ,pay_balance_feeds_f pbf
900: where pet.element_type_id = piv.element_type_id
901: and pet.business_group_id = NVL(c_business_group_id, g_business_group_id)
902: and piv.input_value_id = pbf.input_value_id

Line 963: from pay_input_values_f

959: (c_element_type_id number
960: ,c_input_value_name varchar2
961: ) is
962: select input_value_id
963: from pay_input_values_f
964: where element_type_id = c_element_type_id
965: and name = c_input_value_name;
966:
967: -- Cursor to get value from element entry values table

Line 2000: ,pay_input_values_f process_iv

1996: ,pay_payroll_actions BACT
1997: ,pay_assignment_actions ASSACT
1998: ,pay_payroll_actions PACT
1999: ,pay_run_results RR
2000: ,pay_input_values_f process_iv
2001: ,pay_run_result_values process
2002: ,pay_run_result_values TARGET
2003: ,pay_balance_feeds_f FEED
2004: where BAL_ASSACT.assignment_action_id = p_assignment_action_id

Line 2036: ,pay_input_values_f process_iv

2032: /* Assignment with Date worked for Run */
2033: FROM pay_assignment_actions ASSACT
2034: ,pay_payroll_actions PACT
2035: ,pay_run_results RR
2036: ,pay_input_values_f process_iv
2037: ,pay_run_result_values process
2038: ,pay_run_result_values TARGET
2039: ,pay_balance_feeds_f FEED
2040: where FEED.balance_type_id = p_bal_type_id + DECODE(TARGET.input_value_id,null,0,0)

Line 2068: pay_input_values_f process_iv,

2064: ) IS
2065: SELECT /*+ ORDERED */ 'N'
2066: FROM pay_run_results prr,
2067: pay_element_types_f pet,
2068: pay_input_values_f process_iv,
2069: pay_run_result_values process
2070: WHERE prr.run_result_id = p_run_result_id
2071: and prr.run_result_id = process.run_result_id
2072: and prr.element_type_id = pet.element_type_id