eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_BALANCE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 20: INDEX(PAY_PAYROLL_ACTIONS_PK PPA) */

16: CURSOR get_business_group_id IS
17: select /*+ ORDERED
18: USE_NL(PAA, PPA)
19: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
20: INDEX(PAY_PAYROLL_ACTIONS_PK PPA) */
21: ppa.business_group_id
22: from pay_assignment_actions paa,
23: pay_payroll_actions ppa
24: where paa.assignment_action_id = p_assignment_action_id

Line 23: pay_payroll_actions ppa

19: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
20: INDEX(PAY_PAYROLL_ACTIONS_PK PPA) */
21: ppa.business_group_id
22: from pay_assignment_actions paa,
23: pay_payroll_actions ppa
24: where paa.assignment_action_id = p_assignment_action_id
25: and ppa.payroll_action_id = paa.payroll_action_id;
26: BEGIN
27: OPEN get_business_group_id;

Line 323: INDEX(PAY_PAYROLL_ACTIONS_PK PACT)

319: CURSOR cur_balance_value_asg_run IS
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)

Line 329: pay_payroll_actions PACT,

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,
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

Line 350: INDEX(PAY_PAYROLL_ACTIONS_PK PACT)

346: -- -----------------------------------------------------------------------------
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)

Line 357: pay_payroll_actions PACT,

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,
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

Line 467: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)

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)
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,

Line 472: pay_payroll_actions 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,
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

Line 548: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)

544: CURSOR get_result_value IS
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,

Line 553: pay_payroll_actions 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,
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

Line 630: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)

626: CURSOR get_result_value IS
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,

Line 635: pay_payroll_actions 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,
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

Line 714: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)

710: -- select min(to_date(prrv.result_value,'DD-MON-YYYY'))
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,

Line 719: pay_payroll_actions 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,
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

Line 1248: INDEX(PAY_PAYROLL_ACTIONS_PK PPA) */

1244: CURSOR csr_assignment_action_id IS
1245: SELECT /*+ ORDERED
1246: USE_NL(PAA, PPA)
1247: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
1248: INDEX(PAY_PAYROLL_ACTIONS_PK PPA) */
1249: PAA.ASSIGNMENT_ID,
1250: PPA.EFFECTIVE_DATE
1251: FROM PAY_ASSIGNMENT_ACTIONS PAA,
1252: PAY_PAYROLL_ACTIONS PPA

Line 1252: PAY_PAYROLL_ACTIONS PPA

1248: INDEX(PAY_PAYROLL_ACTIONS_PK PPA) */
1249: PAA.ASSIGNMENT_ID,
1250: PPA.EFFECTIVE_DATE
1251: FROM PAY_ASSIGNMENT_ACTIONS PAA,
1252: PAY_PAYROLL_ACTIONS PPA
1253: WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
1254: AND PAA.ASSIGNMENT_ACTION_ID = p_assignment_action_id;
1255:
1256: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

Line 1258: l_effective_date PAY_PAYROLL_ACTIONS.EFFECTIVE_DATE%TYPE;

1254: AND PAA.ASSIGNMENT_ACTION_ID = p_assignment_action_id;
1255:
1256: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
1257: l_assignment_id PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE;
1258: l_effective_date PAY_PAYROLL_ACTIONS.EFFECTIVE_DATE%TYPE;
1259:
1260: BEGIN
1261: OPEN csr_assignment_action_id;
1262: FETCH csr_assignment_action_id INTO l_assignment_id,l_effective_date;