APPS.INV_TXN_PURGE_MAIN dependencies on ORG_ACCT_PERIODS

Line 50: FROM org_acct_periods

46: CURSOR c_oap IS
47: SELECT period_start_date
48: , schedule_close_date
49: , acct_period_id
50: FROM org_acct_periods
51: WHERE period_start_date <= p_purge_date
52: AND open_flag = 'N'
53: AND organization_id = p_orgid
54: AND acct_period_id >= l_min_period_id

Line 84: FROM org_acct_periods

80:
81: IF l_min_mmt_date IS NOT NULL THEN
82: SELECT acct_period_id
83: INTO l_min_period_id
84: FROM org_acct_periods
85: WHERE organization_id = p_orgid
86: AND TRUNC(period_start_date) <= TRUNC(l_min_mmt_date)
87: AND TRUNC(schedule_close_date) >= TRUNC(l_min_mmt_date)
88: AND open_flag = 'N';

Line 92: FROM org_acct_periods

88: AND open_flag = 'N';
89:
90: SELECT COUNT(acct_period_id)
91: INTO l_num_of_periods
92: FROM org_acct_periods
93: WHERE organization_id = p_orgid
94: AND acct_period_id >= l_min_period_id
95: AND TRUNC(period_start_date) <= TRUNC(p_purge_date)
96: AND open_flag = 'N';