APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_BALANCE_FEEDS_F

Line 906: ,pay_balance_feeds_f pbf

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

Line 1305: ,pay_balance_feeds_f FEED

1301: ,pay_assignment_actions ASSACT
1302: ,pay_payroll_actions PACT
1303: ,pay_run_results RR
1304: ,pay_run_result_values TARGET
1305: ,pay_balance_feeds_f FEED
1306: ,per_time_periods PTP
1307: WHERE BAL_ASSACT.assignment_action_id = p_asg_act_id
1308: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1309: and FEED.balance_type_id = p_balance_type_id + DECODE(TARGET.input_value_id,null,0,0) -- 10510987

Line 2032: ,pay_balance_feeds_f FEED

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

Line 2073: ,pay_balance_feeds_f FEED

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