APPS.PAY_GB_ENROLL_PENSION dependencies on PER_TIME_PERIODS

Line 36: G_TIME_PERIOD_ID PER_TIME_PERIODS.TIME_PERIOD_ID%TYPE;

32: G_EARN_END_DATE DATE;
33: G_EARN_DATE_PAID DATE;
34:
35: G_MODE VARCHAR2(20);
36: G_TIME_PERIOD_ID PER_TIME_PERIODS.TIME_PERIOD_ID%TYPE;
37: G_PAYROLL_ACTION_ID NUMBER;
38: G_PAYROLL_PERIOD_TYPE PAY_PAYROLLS_F.PERIOD_TYPE%TYPE;
39: G_PAYROLL_ID PER_TIME_PERIODS.PAYROLL_ID%TYPE;
40: G_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;

Line 39: G_PAYROLL_ID PER_TIME_PERIODS.PAYROLL_ID%TYPE;

35: G_MODE VARCHAR2(20);
36: G_TIME_PERIOD_ID PER_TIME_PERIODS.TIME_PERIOD_ID%TYPE;
37: G_PAYROLL_ACTION_ID NUMBER;
38: G_PAYROLL_PERIOD_TYPE PAY_PAYROLLS_F.PERIOD_TYPE%TYPE;
39: G_PAYROLL_ID PER_TIME_PERIODS.PAYROLL_ID%TYPE;
40: G_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;
41: G_PERIOD_NAME PER_TIME_PERIODS.PERIOD_NAME%TYPE;
42: G_BUSINESS_GROUP_ID PAY_PAYROLLS_F.BUSINESS_GROUP_ID%TYPE;
43: G_STATE_PENSION_AGE_MEN NUMBER := 65; -- Check

Line 41: G_PERIOD_NAME PER_TIME_PERIODS.PERIOD_NAME%TYPE;

37: G_PAYROLL_ACTION_ID NUMBER;
38: G_PAYROLL_PERIOD_TYPE PAY_PAYROLLS_F.PERIOD_TYPE%TYPE;
39: G_PAYROLL_ID PER_TIME_PERIODS.PAYROLL_ID%TYPE;
40: G_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;
41: G_PERIOD_NAME PER_TIME_PERIODS.PERIOD_NAME%TYPE;
42: G_BUSINESS_GROUP_ID PAY_PAYROLLS_F.BUSINESS_GROUP_ID%TYPE;
43: G_STATE_PENSION_AGE_MEN NUMBER := 65; -- Check
44: G_PENSION_STAGING_DATE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE;
45: G_WORKER_POSTPONEMENT_RULE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE;

Line 222: FROM PER_TIME_PERIODS PTP

218: SELECT TIME_PERIOD_ID,
219: START_DATE,
220: END_DATE
221: , REGULAR_PAYMENT_DATE
222: FROM PER_TIME_PERIODS PTP
223: WHERE PTP.PAYROLL_ID = P_PAYROLL_ID
224: AND REGULAR_PAYMENT_DATE BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE
225: ORDER BY START_DATE;
226: