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_GB_ENROLL_PENSION dependencies on PER_TIME_PERIODS

Line 161: FROM PER_TIME_PERIODS PTP

157: CURSOR C_PRP_DETAILS
158: IS
159: SELECT START_DATE,
160: END_DATE
161: FROM PER_TIME_PERIODS PTP
162: WHERE P_REGULAR_PAYMENT_DATE BETWEEN START_DATE AND END_DATE
163: AND PAYROLL_ID=L_PAYROLL_ID;
164: --To get the Period_type
165: CURSOR C_PERIOD_TYPE(V_PAYROLL_ID NUMBER)

Line 181: PER_TIME_PERIODS PTP

177: ptp.TIME_PERIOD_ID,
178: ptp.PAYROLL_ID
179: FROM PAY_PAYROLL_ACTIONS PPA,
180: PAY_ASSIGNMENT_ACTIONS PAA,
181: PER_TIME_PERIODS PTP
182: WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
183: AND REGULAR_PAYMENT_DATE = PPA.EFFECTIVE_DATE
184: AND ptp.TIME_PERIOD_ID = PPA.TIME_PERIOD_ID
185: -- AND PPA.TIME_PERIOD_ID = NVL(P_TIME_PERIOD,PPA.TIME_PERIOD_ID)

Line 478: FROM PER_TIME_PERIODS PTP

474: L_DATE DATE;
475: CURSOR C_MAX_DATE
476: IS
477: SELECT (PTP.START_DATE-1)
478: FROM PER_TIME_PERIODS PTP
479: WHERE ADD_MONTHS(P_DATE,3) BETWEEN START_DATE AND END_DATE
480: AND PAYROLL_ID=G_PAYROLL_ID;
481: BEGIN
482: OPEN C_MAX_DATE;

Line 499: FROM PER_TIME_PERIODS PTP

495:
496: CURSOR C_MAX_DATE
497: IS
498: SELECT (PTP.START_DATE-1)
499: FROM PER_TIME_PERIODS PTP
500: WHERE ADD_MONTHS(P_DATE,3) BETWEEN START_DATE AND END_DATE
501: AND PAYROLL_ID=G_PAYROLL_ID;
502:
503: BEGIN

Line 718: FROM PER_TIME_PERIODS PTP

714: START_DATE,
715: END_DATE,
716: REGULAR_PAYMENT_DATE ,
717: PERIOD_NAME
718: FROM PER_TIME_PERIODS PTP
719: WHERE PTP.TIME_PERIOD_ID = P_TIME_PERIOD_ID;
720: --To fetch PRP Period Dates
721: CURSOR C_PRP_DETAILS
722: IS

Line 726: FROM PER_TIME_PERIODS PTP

722: IS
723: SELECT START_DATE,
724: END_DATE,
725: REGULAR_PAYMENT_DATE
726: FROM PER_TIME_PERIODS PTP
727: WHERE G_PAYROLL_DATE_PAID BETWEEN START_DATE AND END_DATE
728: AND PAYROLL_ID=G_PAYROLL_ID;
729: --To Fetch Payroll Name
730: CURSOR C_PAYROLL_NAME

Line 1157: PER_TIME_PERIODS PTP

1153: PRT.RUN_TYPE_NAME
1154: FROM PAY_PAYROLL_ACTIONS PPA,
1155: PAY_ASSIGNMENT_ACTIONS PAA,
1156: PAY_RUN_TYPES_F PRT,
1157: PER_TIME_PERIODS PTP
1158: WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
1159: AND REGULAR_PAYMENT_DATE = PPA.EFFECTIVE_DATE
1160: AND ptp.TIME_PERIOD_ID = PPA.TIME_PERIOD_ID
1161: AND PPA.TIME_PERIOD_ID = NVL(P_TIME_PERIOD,PPA.TIME_PERIOD_ID)

Line 1285: FROM per_time_periods

1281: START_DATE,
1282: END_DATE,
1283: PAYROLL_ID,
1284: REGULAR_PAYMENT_DATE DATE_PAID
1285: FROM per_time_periods
1286: WHERE payroll_id IN
1287: (SELECT payroll_id
1288: FROM per_all_assignments_f paaf
1289: WHERE assignment_id = p_assignment_id

Line 1297: per_time_periods ptp

1293: AND regular_payment_date NOT IN
1294: (SELECT effective_date
1295: FROM pay_payroll_actions ppa ,
1296: pay_assignment_actions paa ,
1297: per_time_periods ptp
1298: WHERE ppa.action_type IN ('Q', 'R')
1299: AND ppa.payroll_action_id = paa.payroll_action_id
1300: AND paa.assignment_id = p_assignment_id
1301: AND ppa.time_period_id = ptp.time_period_id

Line 1304: FROM per_time_periods

1300: AND paa.assignment_id = p_assignment_id
1301: AND ppa.time_period_id = ptp.time_period_id
1302: AND ppa.time_period_id IN
1303: (SELECT time_period_id
1304: FROM per_time_periods
1305: WHERE payroll_id IN
1306: (SELECT payroll_id
1307: FROM per_all_assignments_f paaf
1308: WHERE assignment_id = p_assignment_id

Line 2882: FROM PER_TIME_PERIODS

2878: -- To get the Period start date of the period - date paid immeditely after Auto-Enrolment Date
2879: CURSOR C_PENSION_ENTRY_START(P_PAYROLL_ID NUMBER,P_SERVICE_START DATE,P_ASG_START_DATE DATE)
2880: IS
2881: SELECT GREATEST(START_DATE,P_SERVICE_START,P_ASG_START_DATE)
2882: FROM PER_TIME_PERIODS
2883: WHERE REGULAR_PAYMENT_DATE >= V_EFF_START_DATE
2884: AND PAYROLL_ID = P_PAYROLL_ID
2885: ORDER BY REGULAR_PAYMENT_DATE;
2886: CURSOR C_ELEMENT_INFO

Line 3561: select start_date , end_date , REGULAR_PAYMENT_DATE from per_time_periods where payroll_id = G_PAYROLL_ID and FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) between START_DATE and END_DATE;

3557: --To fetch the dates paid which do not have a payroll/assignment action for the assignment id as on period in which staging date falls
3558: -- to get prp_start_date , prp_end_date and regular_payment_date of period in which staging date falls
3559: CURSOR C_STAGING_PRP_PERIOD
3560: is
3561: select start_date , end_date , REGULAR_PAYMENT_DATE from per_time_periods where payroll_id = G_PAYROLL_ID and FND_DATE.canonical_to_date(G_PENSION_STAGING_DATE) between START_DATE and END_DATE;
3562:
3563: CURSOR C_DATES_PAID_MISSED(L_PRP_END_DATE date, L_PRP_START_DATE date)
3564: IS
3565: SELECT TIME_PERIOD_ID,

Line 3570: FROM per_time_periods

3566: START_DATE,
3567: END_DATE,
3568: PAYROLL_ID,
3569: REGULAR_PAYMENT_DATE DATE_PAID
3570: FROM per_time_periods
3571: WHERE payroll_id IN
3572: (SELECT payroll_id
3573: FROM per_all_assignments_f paaf
3574: WHERE assignment_id = p_assignment_id

Line 3582: per_time_periods ptp

3578: AND regular_payment_date NOT IN
3579: (SELECT effective_date
3580: FROM pay_payroll_actions ppa ,
3581: pay_assignment_actions paa ,
3582: per_time_periods ptp
3583: WHERE ppa.action_type IN ('Q', 'R')
3584: AND ppa.payroll_action_id = paa.payroll_action_id
3585: AND paa.assignment_id = p_assignment_id
3586: AND ppa.time_period_id = ptp.time_period_id

Line 3589: FROM per_time_periods

3585: AND paa.assignment_id = p_assignment_id
3586: AND ppa.time_period_id = ptp.time_period_id
3587: AND ppa.time_period_id IN
3588: (SELECT time_period_id
3589: FROM per_time_periods
3590: WHERE payroll_id IN
3591: (SELECT payroll_id
3592: FROM per_all_assignments_f paaf
3593: WHERE assignment_id = p_assignment_id

Line 4044: FROM PER_TIME_PERIODS PTP

4040: --To get Previous Period Start Date
4041: CURSOR PREV_PER_DATE
4042: IS
4043: SELECT PTP.START_DATE
4044: FROM PER_TIME_PERIODS PTP
4045: WHERE (PTP.END_DATE, PTP.PAYROLL_ID) =
4046: (SELECT START_DATE - 1 ,
4047: PAYROLL_ID
4048: FROM PER_TIME_PERIODS PTP1

Line 4048: FROM PER_TIME_PERIODS PTP1

4044: FROM PER_TIME_PERIODS PTP
4045: WHERE (PTP.END_DATE, PTP.PAYROLL_ID) =
4046: (SELECT START_DATE - 1 ,
4047: PAYROLL_ID
4048: FROM PER_TIME_PERIODS PTP1
4049: WHERE PTP1.START_DATE = G_PRP_START_DATE
4050: AND PTP1.END_DATE = G_PRP_END_DATE
4051: AND PTP1.PAYROLL_ID = G_PAYROLL_ID
4052: );