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