APPS.INV_HV_TXN_PURGE dependencies on ORG_ACCT_PERIODS

Line 80: FROM org_acct_periods

76: bad_input_period EXCEPTION;
77:
78: CURSOR get_open_period (x_period_start_date DATE , x_organization_id NUMBER )
79: IS SELECT 'OPEN' sdate
80: FROM org_acct_periods
81: WHERE INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(x_period_start_date,x_organization_id)
82: >= ( SELECT MIN(period_start_date)
83: FROM org_acct_periods
84: WHERE organization_id = x_organization_id

Line 83: FROM org_acct_periods

79: IS SELECT 'OPEN' sdate
80: FROM org_acct_periods
81: WHERE INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(x_period_start_date,x_organization_id)
82: >= ( SELECT MIN(period_start_date)
83: FROM org_acct_periods
84: WHERE organization_id = x_organization_id
85: AND open_flag = 'Y'
86: )
87: AND open_flag = 'Y';