APPS.OPI_EDW_IDS_CALC dependencies on ORG_ACCT_PERIODS

Line 148: FROM org_acct_periods

144:
145: CURSOR l_extraction_periods_csr ( l_organization_id NUMBER) IS
146: SELECT Trunc(period_start_date) start_date,
147: Trunc(schedule_close_date) end_date
148: FROM org_acct_periods
149: WHERE organization_id = l_organization_id
150: AND (( period_start_date between p_from_date
151: and p_to_date )
152: OR( schedule_close_date between p_from_date

Line 255: FROM org_acct_periods

251: l_end_date DATE,
252: l_organization_id NUMBER ) IS
253: SELECT Trunc(MAX(period_start_date)) start_date,
254: Trunc(MAX(schedule_close_date)) end_date
255: FROM org_acct_periods
256: WHERE organization_id = l_organization_id
257: AND schedule_close_date 258: GROUP BY organization_id;
259:

Line 378: FROM org_acct_periods

374: -- In that case, just pick the start of this period.
375: BEGIN
376: SELECT max (trunc (schedule_close_date))
377: INTO l_combs_start_date
378: FROM org_acct_periods
379: WHERE organization_id = p_organization_id
380: AND schedule_close_date < trunc (l_from_date);
381: -- use < instead of <= since if the from date is a period end date,
382: -- then everything has been truncated for this period.

Line 388: FROM org_acct_periods

384: IF (l_combs_start_date IS NULL) THEN
385:
386: SELECT max (trunc (period_start_date))
387: INTO l_combs_start_date
388: FROM org_acct_periods
389: WHERE organization_id = p_organization_id
390: AND period_start_date <= trunc (l_from_date);
391: -- only happens if there is no prior period defined. Just take
392: -- the first period start date then.

Line 1208: FROM org_acct_periods

1204: -- want the subsequent runs for the period to take the lastest
1205: -- cost even if the cost update was not part of this run dates.
1206: SELECT period_start_date
1207: INTO l_from_date_per_start
1208: FROM org_acct_periods
1209: WHERE period_start_date <= trunc (p_from_date)
1210: AND schedule_close_date >= trunc (p_from_date)
1211: AND organization_id = p_organization_id;
1212: