APPS.CST_EAMCOST_PUB dependencies on GL_PERIODS

Line 1197: -- Get data from gl_periods if it is a future period.

1193: WHEN no_data_found THEN -- no open period
1194: open_period := FALSE;
1195: END;
1196:
1197: -- Get data from gl_periods if it is a future period.
1198: IF NOT open_period THEN
1199: l_stmt_num := 130;
1200: /* Bug 2113001 */
1201: l_period_set_name := p_period_set_name;

Line 1212: FROM gl_periods

1208: l_period_id,
1209: l_period_set_name,
1210: l_period_name,
1211: l_period_start_date
1212: FROM gl_periods
1213: WHERE period_set_name = l_period_set_name AND
1214: period_name = l_period_name;
1215: END IF;
1216:

Line 3301: FROM gl_periods gp,

3297: gp.start_date
3298: INTO l_period_set_name,
3299: l_period_name,
3300: l_period_start_date
3301: FROM gl_periods gp,
3302: gl_sets_of_books gsob,
3303: /*org_organization_definitions ood */
3304: cst_organization_definitions ood
3305: WHERE ood.organization_id = l_organization_id

Line 5360: from gl_periods y,

5356: select
5357: y.start_date
5358: into
5359: l_period_start_date
5360: from gl_periods y,
5361: mfg_lookups x
5362: where
5363: y.adjustment_period_flag = 'N' and
5364: x.lookup_type(+) = 'MTL_ACCT_PERIOD_STATUS' and

Line 5381: from gl_periods y,

5377: select
5378: y.end_date
5379: into
5380: l_period_end_date
5381: from gl_periods y,
5382: mfg_lookups x
5383: where
5384: y.adjustment_period_flag = 'N' and
5385: x.lookup_type(+) = 'MTL_ACCT_PERIOD_STATUS' and

Line 5560: from gl_periods y,

5556: select
5557: y.start_date
5558: into
5559: l_period_start_date
5560: from gl_periods y,
5561: mfg_lookups x
5562: where
5563: y.adjustment_period_flag = 'N' and
5564: x.lookup_type(+) = 'MTL_ACCT_PERIOD_STATUS' and

Line 5581: from gl_periods y,

5577: select
5578: y.end_date
5579: into
5580: l_period_end_date
5581: from gl_periods y,
5582: mfg_lookups x
5583: where
5584: y.adjustment_period_flag = 'N' and
5585: x.lookup_type(+) = 'MTL_ACCT_PERIOD_STATUS' and