24: OAP1.PERIOD_START_DATE,
25: OAP2.SCHEDULE_CLOSE_DATE
26: INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
27: FROM
28: ORG_ACCT_PERIODS OAP1,
29: ORG_ACCT_PERIODS OAP2
30: WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
31: AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
32: AND OAP2.ORGANIZATION_ID = P_ORG_ID
25: OAP2.SCHEDULE_CLOSE_DATE
26: INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
27: FROM
28: ORG_ACCT_PERIODS OAP1,
29: ORG_ACCT_PERIODS OAP2
30: WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
31: AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
32: AND OAP2.ORGANIZATION_ID = P_ORG_ID
33: AND OAP2.ACCT_PERIOD_ID = P_PERIOD_ID_TO;