DBA Data[Home] [Help]

APPS.INV_TXN_PURGE_WORKER dependencies on ORG_ACCT_PERIODS

Line 97: FROM ORG_ACCT_PERIODS

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