32: SELECT
33: PERIOD_NAME
34: INTO PERIOD_NAME
35: FROM
36: CST_PAC_PERIODS
37: WHERE PAC_PERIOD_ID = P_PERIOD_ID
38: AND COST_TYPE_ID = P_COST_TYPE
39: AND LEGAL_ENTITY = P_LEGAL_ENTITY;
40: SELECT
45: TO_CHAR(PERIOD_END_DATE
46: ,'DD-MON-RRRR')
47: INTO P_WRITE_OFF_DATE_FROM,P_WRITE_OFF_DATE_TO,FROM_DATE,TO_DATE
48: FROM
49: CST_PAC_PERIODS CPP
50: WHERE CPP.PAC_PERIOD_ID = P_PERIOD_ID
51: AND CPP.LEGAL_ENTITY = P_LEGAL_ENTITY
52: AND CPP.COST_TYPE_ID = P_COST_TYPE;
53: RETURN TRUE;