APPS.HR_GBBAL dependencies on PAY_BALANCE_FEEDS_F

Line 3185: FEED PAY_BALANCE_FEEDS_F_UK2,

3181: BEGIN
3182: --
3183: SELECT /*+ ORDERED INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51,
3184: PACT PAY_PAYROLL_ACTIONS_PK,
3185: FEED PAY_BALANCE_FEEDS_F_UK2,
3186: PPTP PER_TIME_PERIODS_PK,
3187: RR PAY_RUN_RESULTS_N50,
3188: TARGET PAY_RUN_RESULT_VALUES_PK) */
3189: NVL(SUM(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)

Line 3195: ,pay_balance_feeds_f FEED

3191: l_balance
3192: FROM
3193: pay_assignment_actions ASSACT
3194: ,pay_payroll_actions PACT
3195: ,pay_balance_feeds_f FEED
3196: ,per_time_periods PPTP
3197: ,pay_run_results RR
3198: ,pay_run_result_values TARGET
3199: WHERE

Line 3641: PAY_BALANCE_FEEDS_F FEED

3637: , max(decode(FEED.balance_type_id,g_ni_j_id,1,g_ni_j_able_id,1,0))
3638: , max(decode(FEED.balance_type_id,g_ni_l_id,1,g_ni_l_able_id,1,0))
3639: , max(decode(FEED.balance_type_id,g_ni_s_id,1,g_ni_s_able_id,1,0))
3640: from
3641: PAY_BALANCE_FEEDS_F FEED
3642: , PAY_RUN_RESULT_VALUES PRRV
3643: , PAY_RUN_RESULTS PRR
3644: , PER_TIME_PERIODS PPTP
3645: , PAY_PAYROLL_ACTIONS PACT