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_ASSIGNMENT_ACTIONS

Line 10: FUNCTION get_business_group_id(p_assignment_action_id IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)

6: cached boolean := FALSE;
7: g_low_volume pay_action_parameters.parameter_value%type := 'N';
8: --
9: --===============================================================================
10: FUNCTION get_business_group_id(p_assignment_action_id IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
11: --===============================================================================
12: RETURN NUMBER
13: IS
14: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 19: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)

15:
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

Line 22: from pay_assignment_actions paa,

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
25: and ppa.payroll_action_id = paa.payroll_action_id;
26: BEGIN

Line 322: INDEX(PAY_ASSIGNMENT_ACTIONS_PK ASSACT)

318: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
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) */

Line 328: FROM pay_assignment_actions ASSACT,

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,
331: pay_run_results RR,
332: pay_run_result_values TARGET

Line 349: INDEX(PAY_ASSIGNMENT_ACTIONS_PK ASSACT)

345: -- Fix bug#3331016: Removed RULE hint from statement.
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) */

Line 356: pay_assignment_actions ASSACT,

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,
358: pay_balance_feeds_f FEED,
359: pay_run_results RR,
360: pay_run_result_values TARGET

Line 414: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)

410: -- GET_RESULT_VALUE_PAY_VALUE --
411: -----------------------------------------------------------
412: FUNCTION GET_RESULT_VALUE_PAY_VALUE(
413: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
414: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
415: RETURN NUMBER
416: IS
417: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
418: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

Line 466: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)

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

Line 471: from pay_assignment_actions 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,
474: pay_run_result_values prrv
475: where paa.assignment_action_id = p_assignment_action_id

Line 501: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)

497: -----------------------------------------------------------
498: FUNCTION GET_RESULT_VALUE_CHAR(
499: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
500: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
501: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
502: RETURN VARCHAR2
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;

Line 537: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)

533: -----------------------------------------------------------
534: FUNCTION GET_RESULT_VALUE_CHAR(
535: P_ELEMENT_TYPE_ID IN NUMBER,
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.

Line 547: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)

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

Line 552: from pay_assignment_actions 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,
555: pay_run_result_values prrv
556: where paa.assignment_action_id = p_assignment_action_id

Line 582: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)

578: -----------------------------------------------------------
579: FUNCTION GET_RESULT_VALUE_NUMBER(
580: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
581: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
582: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
583: RETURN NUMBER
584: IS
585: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
586: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

Line 619: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)

615: -----------------------------------------------------------
616: FUNCTION GET_RESULT_VALUE_NUMBER(
617: P_ELEMENT_TYPE_ID IN NUMBER,
618: P_INPUT_VALUE_ID IN NUMBER,
619: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
620: RETURN NUMBER
621: IS
622: l_result_value NUMBER;
623: -- This cursor doesn't check action_type.

Line 629: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)

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

Line 634: from pay_assignment_actions 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,
637: pay_run_result_values prrv
638: where paa.assignment_action_id = p_assignment_action_id

Line 664: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)

660: -----------------------------------------------------------
661: FUNCTION GET_RESULT_VALUE_DATE(
662: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
663: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
664: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
665: RETURN DATE
666: IS
667: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
668: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

Line 701: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)

697: -----------------------------------------------------------
698: FUNCTION GET_RESULT_VALUE_DATE(
699: P_ELEMENT_TYPE_ID IN NUMBER,
700: P_INPUT_VALUE_ID IN NUMBER,
701: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
702: RETURN DATE
703: IS
704: l_result_value DATE;
705: -- This cursor doesn't check action_type.

Line 713: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)

709: -- Support for canonical date format
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))

Line 718: from pay_assignment_actions 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,
721: pay_run_result_values prrv
722: where paa.assignment_action_id = p_assignment_action_id

Line 1240: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE

1236: --
1237: --===============================================================================
1238: FUNCTION GET_DEFINED_BALANCE_ID(
1239: P_BALANCE_TYPE_ID IN PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE,
1240: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE
1241: )
1242: RETURN NUMBER IS
1243: --===============================================================================
1244: CURSOR csr_assignment_action_id IS

Line 1247: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)

1243: --===============================================================================
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,

Line 1251: FROM PAY_ASSIGNMENT_ACTIONS PAA,

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
1253: WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
1254: AND PAA.ASSIGNMENT_ACTION_ID = p_assignment_action_id;
1255:

Line 1257: l_assignment_id PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE;

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