59: OAP1.PERIOD_START_DATE,
60: OAP2.SCHEDULE_CLOSE_DATE
61: INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
62: FROM
63: ORG_ACCT_PERIODS OAP1,
64: ORG_ACCT_PERIODS OAP2
65: WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
66: AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
67: AND OAP2.ORGANIZATION_ID = P_ORG_ID
60: OAP2.SCHEDULE_CLOSE_DATE
61: INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
62: FROM
63: ORG_ACCT_PERIODS OAP1,
64: ORG_ACCT_PERIODS OAP2
65: WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
66: AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
67: AND OAP2.ORGANIZATION_ID = P_ORG_ID
68: AND OAP2.ACCT_PERIOD_ID = P_PERIOD_ID_TO;