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.PY_ZA_BAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 91: pay_assignment_actions

87: l_action_sequence NUMBER;
88: --
89: cursor get_sequence(c_assignment_action_id IN NUMBER) is
90: select action_sequence from
91: pay_assignment_actions
92: where assignment_action_id = c_assignment_action_id;
93: --
94: BEGIN
95: --

Line 159: FROM pay_assignment_actions paa,

155: l_assignment_id NUMBER;
156: --
157: cursor get_corr_type (c_assignment_action_id IN NUMBER) is
158: SELECT assignment_id
159: FROM pay_assignment_actions paa,
160: pay_payroll_actions ppa
161: WHERE
162: paa.assignment_action_id = c_assignment_action_id
163: AND ppa.payroll_action_id = paa.payroll_action_id

Line 196: FROM pay_assignment_actions paa,

192: cursor get_latest_id (c_assignment_id IN NUMBER,
193: c_effective_date IN DATE) is
194: SELECT
195: to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
196: FROM pay_assignment_actions paa,
197: pay_payroll_actions ppa
198: WHERE
199: paa.assignment_id = c_assignment_id
200: AND ppa.payroll_action_id = paa.payroll_action_id

Line 209: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)

205: cursor get_latest_id (c_assignment_id IN NUMBER,
206: c_effective_date IN DATE) is
207: SELECT /*+ ORDERED
208: USE_NL(PAA PPA)
209: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
210: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */
211: TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||
212: paa.assignment_action_id),16))
213: FROM pay_assignment_actions paa,

Line 213: FROM pay_assignment_actions paa,

209: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
210: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */
211: TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||
212: paa.assignment_action_id),16))
213: FROM pay_assignment_actions paa,
214: pay_payroll_actions ppa
215: WHERE paa.assignment_id = c_assignment_id
216: AND ppa.payroll_action_id = paa.payroll_action_id
217: AND ppa.effective_date <= c_effective_date

Line 324: pay_assignment_actions paa

320: --
321: cursor c_bal_date is
322: SELECT ppa.effective_date
323: FROM pay_payroll_actions ppa,
324: pay_assignment_actions paa
325: WHERE paa.payroll_action_id = ppa.payroll_action_id
326: AND paa.assignment_action_id = p_assignment_action_id;
327: --
328: begin

Line 365: pay_assignment_actions paa

361: cursor tax_year (c_assignment_action_id IN NUMBER) is
362: SELECT ptp.prd_information1, ppa.payroll_id
363: FROM per_time_periods ptp,
364: pay_payroll_actions ppa,
365: pay_assignment_actions paa
366: WHERE
367: paa.assignment_action_id = c_assignment_action_id
368: AND paa.payroll_action_id = ppa.payroll_action_id
369: AND ppa.time_period_id = ptp.time_period_id;

Line 509: pay_assignment_actions BAL_ASSACT,

505: BACT.effective_date,
506: PTP.regular_payment_date,
507: BACT.business_group_id
508: FROM
509: pay_assignment_actions BAL_ASSACT,
510: pay_payroll_actions BACT,
511: per_time_periods PTP
512: WHERE
513: BAL_ASSACT.assignment_action_id = p_assignment_action_id

Line 851: pay_assignment_actions paa

847: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
848: SELECT ptp.end_date
849: FROM per_time_periods ptp,
850: pay_payroll_actions ppa,
851: pay_assignment_actions paa
852: WHERE
853: paa.assignment_action_id = c_assignment_action_id
854: AND paa.payroll_action_id = ppa.payroll_action_id
855: AND ppa.time_period_id = ptp.time_period_id;

Line 1000: pay_assignment_actions paa

996: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
997: SELECT ptp.end_date
998: FROM per_time_periods ptp,
999: pay_payroll_actions ppa,
1000: pay_assignment_actions paa
1001: WHERE
1002: paa.assignment_action_id = c_assignment_action_id
1003: AND paa.payroll_action_id = ppa.payroll_action_id
1004: AND ppa.time_period_id = ptp.time_period_id;

Line 1067: pay_assignment_actions paa

1063: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
1064: SELECT ptp.end_date
1065: FROM per_time_periods ptp,
1066: pay_payroll_actions ppa,
1067: pay_assignment_actions paa
1068: WHERE
1069: paa.assignment_action_id = c_assignment_action_id
1070: AND paa.payroll_action_id = ppa.payroll_action_id
1071: AND ppa.time_period_id = ptp.time_period_id;

Line 1377: pay_assignment_actions paa

1373: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
1374: SELECT ptp.end_date
1375: FROM per_time_periods ptp,
1376: pay_payroll_actions ppa,
1377: pay_assignment_actions paa
1378: WHERE
1379: paa.assignment_action_id = c_assignment_action_id
1380: AND paa.payroll_action_id = ppa.payroll_action_id
1381: AND ppa.time_period_id = ptp.time_period_id;

Line 1442: pay_assignment_actions paa

1438: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
1439: SELECT ptp.end_date
1440: FROM per_time_periods ptp,
1441: pay_payroll_actions ppa,
1442: pay_assignment_actions paa
1443: WHERE
1444: paa.assignment_action_id = c_assignment_action_id
1445: AND paa.payroll_action_id = ppa.payroll_action_id
1446: AND ppa.time_period_id = ptp.time_period_id;

Line 1591: pay_assignment_actions paa

1587: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
1588: SELECT ptp.pay_advice_date
1589: FROM per_time_periods ptp,
1590: pay_payroll_actions ppa,
1591: pay_assignment_actions paa
1592: WHERE
1593: paa.assignment_action_id = c_assignment_action_id
1594: AND paa.payroll_action_id = ppa.payroll_action_id
1595: AND ppa.time_period_id = ptp.time_period_id;

Line 1659: pay_assignment_actions paa

1655: cursor owning_month_end_date (c_assignment_action_id IN NUMBER) is
1656: SELECT ptp.pay_advice_date
1657: FROM per_time_periods ptp,
1658: pay_payroll_actions ppa,
1659: pay_assignment_actions paa
1660: WHERE
1661: paa.assignment_action_id = c_assignment_action_id
1662: AND paa.payroll_action_id = ppa.payroll_action_id
1663: AND ppa.time_period_id = ptp.time_period_id;

Line 1669: pay_assignment_actions paa

1665: cursor original_month_end_date (c_assignment_action_id IN NUMBER) is
1666: SELECT ptp.pay_advice_date
1667: FROM per_time_periods ptp,
1668: pay_payroll_actions ppa,
1669: pay_assignment_actions paa
1670: WHERE
1671: paa.assignment_action_id = c_assignment_action_id
1672: AND paa.payroll_action_id = ppa.payroll_action_id
1673: AND ppa.time_period_id = ptp.time_period_id;

Line 1781: pay_assignment_actions paa

1777: cursor latest_action_quarter (c_assignment_action_id IN NUMBER) is
1778: SELECT ptp.prd_information2, ppa.payroll_id
1779: FROM per_time_periods ptp,
1780: pay_payroll_actions ppa,
1781: pay_assignment_actions paa
1782: WHERE
1783: paa.assignment_action_id = c_assignment_action_id
1784: AND paa.payroll_action_id = ppa.payroll_action_id
1785: AND ppa.time_period_id = ptp.time_period_id;

Line 1799: pay_assignment_actions paa

1795: cursor orig_action_quarter (c_assignment_action_id IN NUMBER) is
1796: SELECT ptp.prd_information2
1797: FROM per_time_periods ptp,
1798: pay_payroll_actions ppa,
1799: pay_assignment_actions paa
1800: WHERE
1801: paa.assignment_action_id = c_assignment_action_id
1802: AND paa.payroll_action_id = ppa.payroll_action_id
1803: AND ppa.time_period_id = ptp.time_period_id;

Line 2304: pay_assignment_actions paa

2300: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2301: SELECT ptp.end_date
2302: FROM per_time_periods ptp,
2303: pay_payroll_actions ppa,
2304: pay_assignment_actions paa
2305: WHERE
2306: paa.assignment_action_id = c_assignment_action_id
2307: AND paa.payroll_action_id = ppa.payroll_action_id
2308: AND ppa.time_period_id = ptp.time_period_id;

Line 2369: pay_assignment_actions paa

2365: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2366: SELECT ptp.end_date
2367: FROM per_time_periods ptp,
2368: pay_payroll_actions ppa,
2369: pay_assignment_actions paa
2370: WHERE
2371: paa.assignment_action_id = c_assignment_action_id
2372: AND paa.payroll_action_id = ppa.payroll_action_id
2373: AND ppa.time_period_id = ptp.time_period_id;

Line 2517: pay_assignment_actions paa

2513: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2514: SELECT ptp.pay_advice_date
2515: FROM per_time_periods ptp,
2516: pay_payroll_actions ppa,
2517: pay_assignment_actions paa
2518: WHERE
2519: paa.assignment_action_id = c_assignment_action_id
2520: AND paa.payroll_action_id = ppa.payroll_action_id
2521: AND ppa.time_period_id = ptp.time_period_id;

Line 2585: pay_assignment_actions paa

2581: cursor owning_month_end_date (c_assignment_action_id IN NUMBER) is
2582: SELECT ptp.pay_advice_date
2583: FROM per_time_periods ptp,
2584: pay_payroll_actions ppa,
2585: pay_assignment_actions paa
2586: WHERE
2587: paa.assignment_action_id = c_assignment_action_id
2588: AND paa.payroll_action_id = ppa.payroll_action_id
2589: AND ppa.time_period_id = ptp.time_period_id;

Line 2595: pay_assignment_actions paa

2591: cursor original_month_end_date (c_assignment_action_id IN NUMBER) is
2592: SELECT ptp.pay_advice_date
2593: FROM per_time_periods ptp,
2594: pay_payroll_actions ppa,
2595: pay_assignment_actions paa
2596: WHERE
2597: paa.assignment_action_id = c_assignment_action_id
2598: AND paa.payroll_action_id = ppa.payroll_action_id
2599: AND ppa.time_period_id = ptp.time_period_id;

Line 2747: pay_assignment_actions paa

2743: cursor calendar_year (c_assignment_action_id IN NUMBER) is
2744: SELECT to_number(ptp.prd_information3)
2745: FROM per_time_periods ptp,
2746: pay_payroll_actions ppa,
2747: pay_assignment_actions paa
2748: WHERE
2749: paa.assignment_action_id = c_assignment_action_id
2750: AND paa.payroll_action_id = ppa.payroll_action_id
2751: AND ppa.time_period_id = ptp.time_period_id;

Line 2817: pay_assignment_actions paa

2813: cursor original_cal_year (c_assignment_action IN NUMBER) is
2814: select to_number(ptp.prd_information3)
2815: from per_time_periods ptp,
2816: pay_payroll_actions ppa,
2817: pay_assignment_actions paa
2818: where
2819: paa.assignment_action_id = c_assignment_action
2820: and ppa.payroll_action_id = paa.payroll_action_id
2821: and ptp.time_period_id = ppa.time_period_id;

Line 2827: pay_assignment_actions paa

2823: cursor owning_cal_year (c_assignment_action IN NUMBER) is
2824: select to_number(ptp.prd_information3)
2825: from per_time_periods ptp,
2826: pay_payroll_actions ppa,
2827: pay_assignment_actions paa
2828: where
2829: paa.assignment_action_id = c_assignment_action
2830: and ppa.payroll_action_id = paa.payroll_action_id
2831: and ptp.time_period_id = ppa.time_period_id;

Line 2946: ,pay_assignment_actions ASSACT

2942: ,pay_run_result_values TARGET
2943: ,pay_run_results RR
2944: ,pay_payroll_actions PACT
2945: ,per_time_periods PPTP
2946: ,pay_assignment_actions ASSACT
2947: WHERE
2948: FEED.balance_type_id = P_BALANCE_TYPE_ID
2949: AND FEED.input_value_id = TARGET.input_value_id
2950: AND TARGET.run_result_id = RR.run_result_id

Line 3210: pay_assignment_actions paa

3206: SELECT ptp.end_date
3207: INTO l_end_date
3208: FROM per_time_periods ptp,
3209: pay_payroll_actions ppa,
3210: pay_assignment_actions paa
3211: WHERE paa.assignment_action_id = c_assignment_action_id
3212: AND paa.payroll_action_id = ppa.payroll_action_id
3213: AND ppa.time_period_id = ptp.time_period_id;
3214: --

Line 3232: pay_assignment_actions paa

3228: SELECT ptp.pay_advice_date
3229: INTO l_end_date
3230: FROM per_time_periods ptp,
3231: pay_payroll_actions ppa,
3232: pay_assignment_actions paa
3233: WHERE paa.assignment_action_id = c_assignment_action_id
3234: AND paa.payroll_action_id = ppa.payroll_action_id
3235: AND ppa.time_period_id = ptp.time_period_id;
3236: --

Line 3254: pay_assignment_actions paa

3250: SELECT to_number(ptp.prd_information3)
3251: INTO l_calendar_year
3252: FROM per_time_periods ptp,
3253: pay_payroll_actions ppa,
3254: pay_assignment_actions paa
3255: WHERE paa.assignment_action_id = c_assignment_action_id
3256: AND paa.payroll_action_id = ppa.payroll_action_id
3257: AND ppa.time_period_id = ptp.time_period_id;
3258: --

Line 3280: pay_assignment_actions paa

3276: CURSOR latest_action_quarter (c_assignment_action_id IN NUMBER) is
3277: SELECT ptp.prd_information2, ppa.payroll_id
3278: FROM per_time_periods ptp,
3279: pay_payroll_actions ppa,
3280: pay_assignment_actions paa
3281: WHERE paa.assignment_action_id = c_assignment_action_id
3282: AND paa.payroll_action_id = ppa.payroll_action_id
3283: AND ppa.time_period_id = ptp.time_period_id;
3284: --

Line 3337: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)

3333: c_effective_date IN DATE)
3334: IS
3335: SELECT /*+ ORDERED
3336: USE_NL(PAA PPA)
3337: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
3338: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */
3339: TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||
3340: paa.assignment_action_id),16))
3341: FROM pay_assignment_actions paa,

Line 3341: FROM pay_assignment_actions paa,

3337: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
3338: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */
3339: TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||
3340: paa.assignment_action_id),16))
3341: FROM pay_assignment_actions paa,
3342: pay_payroll_actions ppa
3343: WHERE paa.assignment_id = c_assignment_id
3344: AND ppa.payroll_action_id = paa.payroll_action_id
3345: AND ppa.effective_date <= c_effective_date

Line 3459: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)

3455: c_effective_date IN DATE)
3456: IS
3457: SELECT /*+ ORDERED
3458: USE_NL(PAA PPA)
3459: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
3460: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */
3461: TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||
3462: paa.assignment_action_id),16))
3463: FROM pay_assignment_actions paa,

Line 3463: FROM pay_assignment_actions paa,

3459: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
3460: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */
3461: TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||
3462: paa.assignment_action_id),16))
3463: FROM pay_assignment_actions paa,
3464: pay_payroll_actions ppa
3465: WHERE paa.assignment_id = c_assignment_id
3466: AND ppa.payroll_action_id = paa.payroll_action_id
3467: AND ppa.effective_date <= c_effective_date