[Home] [Help]
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,
329: pay_payroll_actions PACT,
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
335: and RR.assignment_action_id = ASSACT.assignment_action_id
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
356: pay_assignment_actions ASSACT,
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
363: and RR.assignment_action_id = ASSACT.assignment_action_id
458: l_result_value number;
459: --
460: -- This cursor doesn't check action_type.
461: -- This cursor restrict optimizer not to use
462: -- PAY_RUN_RESULTS_N1 index in PAY_RUN_RESULTS.
463: CURSOR get_result_value_pay_value IS
464: select /*+ ORDERED
465: USE_NL(PAA, PPA, PRR, PRRV)
466: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
464: select /*+ ORDERED
465: USE_NL(PAA, PPA, PRR, PRRV)
466: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
467: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)
468: INDEX(PAY_RUN_RESULTS_N50 PRR)
469: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
470: sum(fnd_number.canonical_to_number(prrv.result_value))
471: from pay_assignment_actions paa,
472: pay_payroll_actions ppa,
469: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
470: sum(fnd_number.canonical_to_number(prrv.result_value))
471: from pay_assignment_actions paa,
472: pay_payroll_actions ppa,
473: pay_run_results prr,
474: pay_run_result_values prrv
475: where paa.assignment_action_id = p_assignment_action_id
476: and ppa.payroll_action_id = paa.payroll_action_id
477: and prr.assignment_action_id = paa.assignment_action_id
539: IS
540: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;
541: -- This cursor doesn't check action_type.
542: -- This cursor restrict optimizer not to use
543: -- PAY_RUN_RESULTS_N1 index in PAY_RUN_RESULTS.
544: CURSOR get_result_value IS
545: select /*+ ORDERED
546: USE_NL(PAA, PPA, PRR, PRRV)
547: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
545: select /*+ ORDERED
546: USE_NL(PAA, PPA, PRR, PRRV)
547: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
548: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)
549: INDEX(PAY_RUN_RESULTS_N50 PRR)
550: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
551: min(prrv.result_value)
552: from pay_assignment_actions paa,
553: pay_payroll_actions ppa,
550: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
551: min(prrv.result_value)
552: from pay_assignment_actions paa,
553: pay_payroll_actions ppa,
554: pay_run_results prr,
555: pay_run_result_values prrv
556: where paa.assignment_action_id = p_assignment_action_id
557: and ppa.payroll_action_id = paa.payroll_action_id
558: and prr.assignment_action_id = paa.assignment_action_id
621: IS
622: l_result_value NUMBER;
623: -- This cursor doesn't check action_type.
624: -- This cursor restrict optimizer not to use
625: -- PAY_RUN_RESULTS_N1 index in PAY_RUN_RESULTS.
626: CURSOR get_result_value IS
627: select /*+ ORDERED
628: USE_NL(PAA, PPA, PRR, PRRV)
629: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
627: select /*+ ORDERED
628: USE_NL(PAA, PPA, PRR, PRRV)
629: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
630: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)
631: INDEX(PAY_RUN_RESULTS_N50 PRR)
632: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
633: min(fnd_number.canonical_to_number(prrv.result_value))
634: from pay_assignment_actions paa,
635: pay_payroll_actions ppa,
632: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
633: min(fnd_number.canonical_to_number(prrv.result_value))
634: from pay_assignment_actions paa,
635: pay_payroll_actions ppa,
636: pay_run_results prr,
637: pay_run_result_values prrv
638: where paa.assignment_action_id = p_assignment_action_id
639: and ppa.payroll_action_id = paa.payroll_action_id
640: and prr.assignment_action_id = paa.assignment_action_id
703: IS
704: l_result_value DATE;
705: -- This cursor doesn't check action_type.
706: -- This cursor restrict optimizer not to use
707: -- PAY_RUN_RESULTS_N1 index in PAY_RUN_RESULTS.
708: CURSOR get_result_value IS
709: -- Support for canonical date format
710: -- select min(to_date(prrv.result_value,'DD-MON-YYYY'))
711: select /*+ ORDERED
711: select /*+ ORDERED
712: USE_NL(PAA, PPA, PRR, PRRV)
713: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
714: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)
715: INDEX(PAY_RUN_RESULTS_N50 PRR)
716: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
717: min(fnd_date.canonical_to_date(prrv.result_value))
718: from pay_assignment_actions paa,
719: pay_payroll_actions ppa,
716: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
717: min(fnd_date.canonical_to_date(prrv.result_value))
718: from pay_assignment_actions paa,
719: pay_payroll_actions ppa,
720: pay_run_results prr,
721: pay_run_result_values prrv
722: where paa.assignment_action_id = p_assignment_action_id
723: and ppa.payroll_action_id = paa.payroll_action_id
724: and prr.assignment_action_id = paa.assignment_action_id