DBA Data[Home] [Help]

APPS.PAY_PAYGBTPL_XMLP_PKG dependencies on PER_TIME_PERIODS

Line 45: PER_TIME_PERIODS PTP

41: ,0))
42: ,'DD-MM-YYYY')
43: INTO C_TY_START
44: FROM
45: PER_TIME_PERIODS PTP
46: WHERE PTP.TIME_PERIOD_ID = P_PAYROLL_PERIOD_ID;
47: EXCEPTION
48: WHEN NO_DATA_FOUND THEN
49: NULL;

Line 326: PER_TIME_PERIODS PTP

322: PTP.START_DATE,
323: PTP.REGULAR_PAYMENT_DATE
324: INTO L_PERIOD_START,L_PERIOD_END
325: FROM
326: PER_TIME_PERIODS PTP
327: WHERE PTP.TIME_PERIOD_ID = P_PAYROLL_PERIOD_ID;
328: IF (L_TIME_PERIOD_ID <> P_PAYROLL_PERIOD_ID) THEN
329: L_PERIOD_FLAG := 'Y';
330: END IF;

Line 507: PER_TIME_PERIODS BPTP,

503: BPTP.REGULAR_PAYMENT_DATE,
504: BPTPT.NUMBER_PER_FISCAL_YEAR
505: INTO V_REG_PAY_DATE,V_NO_PER_FISC
506: FROM
507: PER_TIME_PERIODS BPTP,
508: PER_TIME_PERIOD_TYPES BPTPT
509: WHERE BPTP.TIME_PERIOD_ID = P_PAYROLL_PERIOD_ID
510: AND BPTP.PERIOD_TYPE = BPTPT.PERIOD_TYPE;
511: C_PERIOD_DATE := HR_GBBAL.SPAN_START(V_REG_PAY_DATE