APPS.PAY_JP_BALANCE_PKG dependencies on PAY_BALANCE_FEEDS_F

Line 324: INDEX(PAY_BALANCE_FEEDS_F_FK1 FEED)

320: SELECT /*+ ORDERED
321: USE_NL(ASSACT, PACT, FEED, RR, TARGET)
322: INDEX(PAY_ASSIGNMENT_ACTIONS_PK ASSACT)
323: INDEX(PAY_PAYROLL_ACTIONS_PK PACT)
324: INDEX(PAY_BALANCE_FEEDS_F_FK1 FEED)
325: INDEX(PAY_RUN_RESULTS_N50 RR)
326: INDEX(PAY_RUN_RESULT_VALUES_PK TARGET) */
327: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
328: FROM pay_assignment_actions ASSACT,

Line 330: pay_balance_feeds_f FEED,

326: INDEX(PAY_RUN_RESULT_VALUES_PK TARGET) */
327: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
328: FROM pay_assignment_actions ASSACT,
329: pay_payroll_actions PACT,
330: pay_balance_feeds_f FEED,
331: pay_run_results RR,
332: pay_run_result_values TARGET
333: where ASSACT.assignment_action_id = p_assignment_action_id
334: and PACT.payroll_action_id = ASSACT.payroll_action_id

Line 351: INDEX(PAY_BALANCE_FEEDS_F_FK1 FEED)

347: SELECT /*+ ORDERED
348: USE_NL(ASSACT, PACT, FEED, RR, TARGET)
349: INDEX(PAY_ASSIGNMENT_ACTIONS_PK ASSACT)
350: INDEX(PAY_PAYROLL_ACTIONS_PK PACT)
351: INDEX(PAY_BALANCE_FEEDS_F_FK1 FEED)
352: INDEX(PAY_RUN_RESULTS_N50 RR)
353: INDEX(PAY_RUN_RESULT_VALUES_PK TARGET) */
354: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
355: FROM

Line 358: pay_balance_feeds_f FEED,

354: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
355: FROM
356: pay_assignment_actions ASSACT,
357: pay_payroll_actions PACT,
358: pay_balance_feeds_f FEED,
359: pay_run_results RR,
360: pay_run_result_values TARGET
361: where ASSACT.assignment_action_id = p_assignment_action_id
362: and PACT.payroll_action_id = ASSACT.payroll_action_id