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