[Home] [Help]
93: -- accounting periods for the Max_date specified
94: begin
95: SELECT 1
96: into l_tempvar
97: FROM ORG_ACCT_PERIODS
98: WHERE ORGANIZATION_ID = p_organization_id
99: AND SCHEDULE_CLOSE_DATE >= l_max_date
100: AND OPEN_FLAG = 'N' AND ROWNUM < 2;
101: exception