APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_INPUT_VALUES_F

Line 905: ,pay_input_values_f piv

901: ) is
902: select pet.element_type_id element_type_id
903: ,piv.input_value_id input_value_id --Vibhor : PTS
904: from pay_element_types_f pet
905: ,pay_input_values_f piv
906: ,pay_balance_feeds_f pbf
907: where pet.element_type_id = piv.element_type_id
908: and pet.business_group_id = NVL(c_business_group_id, g_business_group_id)
909: and piv.input_value_id = pbf.input_value_id

Line 972: from pay_input_values_f

968: (c_element_type_id number
969: ,c_input_value_name varchar2
970: ) is
971: select input_value_id
972: from pay_input_values_f
973: where element_type_id = c_element_type_id
974: and name = c_input_value_name;
975:
976: -- Cursor to get value from element entry values table

Line 2029: ,pay_input_values_f process_iv

2025: ,pay_assignment_actions ASSACT
2026: ,pay_payroll_actions PACT
2027: ,pay_run_results RR
2028: ,pay_element_types_f pet
2029: ,pay_input_values_f process_iv
2030: ,pay_run_result_values process
2031: ,pay_run_result_values TARGET
2032: ,pay_balance_feeds_f FEED
2033: where BAL_ASSACT.assignment_action_id = p_assignment_action_id

Line 2070: ,pay_input_values_f process_iv

2066: /* Assignment with Date worked for Run */
2067: FROM pay_assignment_actions ASSACT
2068: ,pay_payroll_actions PACT
2069: ,pay_run_results RR
2070: ,pay_input_values_f process_iv
2071: ,pay_run_result_values process
2072: ,pay_run_result_values TARGET
2073: ,pay_balance_feeds_f FEED
2074: where FEED.balance_type_id = p_bal_type_id + DECODE(TARGET.input_value_id,null,0,0)

Line 2102: pay_input_values_f process_iv,

2098: ) IS
2099: SELECT /*+ ORDERED */ 'N'
2100: FROM pay_run_results prr,
2101: pay_element_types_f pet,
2102: pay_input_values_f process_iv,
2103: pay_run_result_values process
2104: WHERE prr.run_result_id = p_run_result_id
2105: and prr.run_result_id = process.run_result_id
2106: and prr.element_type_id = pet.element_type_id