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 PER_TIME_PERIODS

Line 363: FROM per_time_periods ptp,

359: -- Get the tax year end date
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

Line 373: FROM per_time_periods ptp

369: AND ppa.time_period_id = ptp.time_period_id;
370: --
371: cursor tax_year_end (c_tax_year IN NUMBER, c_payroll_id IN NUMBER) is
372: SELECT max(ptp.end_date)
373: FROM per_time_periods ptp
374: WHERE
375: ptp.prd_information1 = c_tax_year
376: AND ptp.payroll_id = c_payroll_id;
377: --

Line 511: per_time_periods PTP

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
515: AND BACT.payroll_action_id = BAL_ASSACT.payroll_action_id;

Line 849: FROM per_time_periods ptp,

845: l_end_date DATE;
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

Line 998: FROM per_time_periods ptp,

994: l_end_date DATE;
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

Line 1065: FROM per_time_periods ptp,

1061: l_defined_bal_id NUMBER;
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

Line 1375: FROM per_time_periods ptp,

1371: -- Has the processing time period expired
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

Line 1440: FROM per_time_periods ptp,

1436: l_defined_bal_id NUMBER;
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

Line 1589: FROM per_time_periods ptp,

1585: -- Has the processing time period expired (Month end date)
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

Line 1657: FROM per_time_periods ptp,

1653: -- Has the processing time period expired (Month end date)
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

Line 1667: FROM per_time_periods ptp,

1663: AND ppa.time_period_id = ptp.time_period_id;
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

Line 1779: FROM per_time_periods ptp,

1775: l_orig_action_quarter NUMBER;
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

Line 1789: FROM per_time_periods ptp

1785: AND ppa.time_period_id = ptp.time_period_id;
1786: --
1787: cursor effective_date_quarter (c_effective_date IN DATE, c_payroll_id IN NUMBER) is
1788: SELECT ptp.prd_information2
1789: FROM per_time_periods ptp
1790: WHERE
1791: ptp.start_date <= c_effective_date
1792: AND ptp.end_date >= c_effective_date
1793: AND ptp.payroll_id = c_payroll_id;

Line 1797: FROM per_time_periods ptp,

1793: AND ptp.payroll_id = c_payroll_id;
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

Line 2302: FROM per_time_periods ptp,

2298: -- Has the processing time period expired
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

Line 2367: FROM per_time_periods ptp,

2363: l_defined_bal_id NUMBER;
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

Line 2515: FROM per_time_periods ptp,

2511: -- Has the processing time period expired (Month end date)
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

Line 2583: FROM per_time_periods ptp,

2579: -- Has the processing time period expired (Month end date)
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

Line 2593: FROM per_time_periods ptp,

2589: AND ppa.time_period_id = ptp.time_period_id;
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

Line 2745: FROM per_time_periods ptp,

2741: l_calendar_year NUMBER;
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

Line 2815: from per_time_periods ptp,

2811: l_owning_cal_year NUMBER;
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

Line 2825: from per_time_periods ptp,

2821: and ptp.time_period_id = ppa.time_period_id;
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

Line 2945: ,per_time_periods PPTP

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
2949: AND FEED.input_value_id = TARGET.input_value_id

Line 3208: FROM per_time_periods ptp,

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

Line 3230: FROM per_time_periods ptp,

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

Line 3252: FROM per_time_periods ptp,

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

Line 3278: FROM per_time_periods ptp,

3274: l_effective_date_quarter NUMBER;
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

Line 3287: FROM per_time_periods ptp

3283: AND ppa.time_period_id = ptp.time_period_id;
3284: --
3285: CURSOR effective_date_quarter (c_effective_date IN DATE, c_payroll_id IN NUMBER) is
3286: SELECT ptp.prd_information2
3287: FROM per_time_periods ptp
3288: WHERE ptp.start_date <= c_effective_date
3289: AND ptp.end_date >= c_effective_date
3290: AND ptp.payroll_id = c_payroll_id;
3291: --