APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_BALANCE_FEEDS_F

Line 899: ,pay_balance_feeds_f pbf

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
903: and pbf.balance_type_id = c_balance_type_id

Line 1284: ,pay_balance_feeds_f FEED

1280: ,pay_assignment_actions ASSACT
1281: ,pay_payroll_actions PACT
1282: ,pay_run_results RR
1283: ,pay_run_result_values TARGET
1284: ,pay_balance_feeds_f FEED
1285: ,per_time_periods PTP
1286: WHERE BAL_ASSACT.assignment_action_id = p_asg_act_id
1287: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1288: and FEED.balance_type_id = p_balance_type_id + DECODE(TARGET.input_value_id,null,0,0) -- 10510987

Line 2003: ,pay_balance_feeds_f FEED

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
2005: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
2006: and FEED.balance_type_id = p_bal_type_id + DECODE(TARGET.input_value_id,null,0,0)
2007: and FEED.input_value_id = TARGET.input_value_id

Line 2039: ,pay_balance_feeds_f FEED

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)
2041: and FEED.input_value_id = TARGET.input_value_id
2042: and nvl(TARGET.result_value,'0') <> '0'
2043: and TARGET.run_result_id = RR.run_result_id