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_RUN_RESULT_VALUES

Line 326: INDEX(PAY_RUN_RESULT_VALUES_PK 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,
330: pay_balance_feeds_f FEED,

Line 332: pay_run_result_values TARGET

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
336: and RR.status in ('P','PA')

Line 353: INDEX(PAY_RUN_RESULT_VALUES_PK 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,
357: pay_payroll_actions PACT,

Line 360: pay_run_result_values TARGET

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
364: and RR.status in ('P','PA')

Line 469: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */

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,
473: pay_run_results prr,

Line 474: pay_run_result_values 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
478: and prr.element_type_id + 0 = p_element_type_id

Line 507: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;

503: IS
504: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
505: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
506: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
507: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;
508: BEGIN
509: l_result_value := NULL;
510:
511: l_business_group_id := get_business_group_id(p_assignment_action_id);

Line 540: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;

536: P_INPUT_VALUE_ID IN NUMBER,
537: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
538: RETURN VARCHAR2
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

Line 550: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */

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,
554: pay_run_results prr,

Line 555: pay_run_result_values 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
559: and prr.element_type_id + 0 = p_element_type_id

Line 632: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */

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,
636: pay_run_results prr,

Line 637: pay_run_result_values 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
641: and prr.element_type_id + 0 = p_element_type_id

Line 716: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */

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,
720: pay_run_results prr,

Line 721: pay_run_result_values 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
725: and prr.element_type_id + 0 = p_element_type_id