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_PAYROLL_ACTIONS

Line 160: pay_payroll_actions ppa

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
164: AND ppa.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 197: pay_payroll_actions ppa

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
201: AND ppa.effective_date <= c_effective_date

Line 210: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */

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,
214: pay_payroll_actions ppa

Line 214: pay_payroll_actions ppa

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
218: AND ppa.action_type IN ('R', 'Q', 'I', 'V', 'B');

Line 323: FROM pay_payroll_actions ppa,

319: l_effective_date date;
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: --

Line 364: pay_payroll_actions ppa,

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

Line 510: pay_payroll_actions BACT,

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
514: AND PTP.time_period_id = BACT.time_period_id

Line 850: pay_payroll_actions ppa,

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

Line 999: pay_payroll_actions ppa,

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

Line 1066: pay_payroll_actions ppa,

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

Line 1376: pay_payroll_actions ppa,

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

Line 1441: pay_payroll_actions ppa,

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

Line 1590: pay_payroll_actions ppa,

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

Line 1658: pay_payroll_actions ppa,

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

Line 1668: pay_payroll_actions ppa,

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

Line 1780: pay_payroll_actions ppa,

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

Line 1798: pay_payroll_actions ppa,

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

Line 2303: pay_payroll_actions ppa,

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

Line 2368: pay_payroll_actions ppa,

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

Line 2516: pay_payroll_actions ppa,

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

Line 2584: pay_payroll_actions ppa,

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

Line 2594: pay_payroll_actions ppa,

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

Line 2746: pay_payroll_actions ppa,

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

Line 2816: pay_payroll_actions ppa,

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

Line 2826: pay_payroll_actions ppa,

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

Line 2944: ,pay_payroll_actions PACT

2940: FROM
2941: pay_balance_feeds_f FEED
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

Line 3209: pay_payroll_actions ppa,

3205: BEGIN
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;

Line 3231: pay_payroll_actions ppa,

3227: BEGIN
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;

Line 3253: pay_payroll_actions ppa,

3249: BEGIN
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;

Line 3279: pay_payroll_actions ppa,

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

Line 3338: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */

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,
3342: pay_payroll_actions ppa

Line 3342: pay_payroll_actions ppa

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
3346: AND ppa.action_type IN ('R', 'Q', 'I', 'V', 'B');

Line 3460: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */

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,
3464: pay_payroll_actions ppa

Line 3464: pay_payroll_actions ppa

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
3468: AND ppa.action_type IN ('R', 'Q', 'I', 'V', 'B');