APPS.HR_GBBAL dependencies on PAY_BALANCE_FEEDS_F

Line 3191: FEED PAY_BALANCE_FEEDS_F_UK2,

3187: BEGIN
3188: --
3189: SELECT /*+ ORDERED INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51,
3190: PACT PAY_PAYROLL_ACTIONS_PK,
3191: FEED PAY_BALANCE_FEEDS_F_UK2,
3192: PPTP PER_TIME_PERIODS_PK,
3193: RR PAY_RUN_RESULTS_N50,
3194: TARGET PAY_RUN_RESULT_VALUES_PK) */
3195: NVL(SUM(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)

Line 3201: ,pay_balance_feeds_f FEED

3197: l_balance
3198: FROM
3199: pay_assignment_actions ASSACT
3200: ,pay_payroll_actions PACT
3201: ,pay_balance_feeds_f FEED
3202: ,per_time_periods PPTP
3203: ,pay_run_results RR
3204: ,pay_run_result_values TARGET
3205: WHERE

Line 3724: PAY_BALANCE_FEEDS_F FEED

3720: , max(decode(FEED.balance_type_id,g_ni_j_id,1,g_ni_j_able_id,1,0))
3721: , max(decode(FEED.balance_type_id,g_ni_l_id,1,g_ni_l_able_id,1,0))
3722: , max(decode(FEED.balance_type_id,g_ni_s_id,1,g_ni_s_able_id,1,0))
3723: from
3724: PAY_BALANCE_FEEDS_F FEED
3725: , PAY_RUN_RESULT_VALUES PRRV
3726: , PAY_RUN_RESULTS PRR
3727: , PER_TIME_PERIODS PPTP
3728: , PAY_PAYROLL_ACTIONS PACT