APPS.CST_EAMCOST_PUB dependencies on GL_PERIODS

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

971: WHEN no_data_found THEN -- no open period
972: open_period := FALSE;
973: END;
974:
975: -- Get data from gl_periods if it is a future period.
976: IF NOT open_period THEN
977: l_stmt_num := 130;
978: /* Bug 2113001 */
979: l_period_set_name := p_period_set_name;

Line 990: FROM gl_periods

986: l_period_id,
987: l_period_set_name,
988: l_period_name,
989: l_period_start_date
990: FROM gl_periods
991: WHERE period_set_name = l_period_set_name AND
992: period_name = l_period_name;
993: END IF;
994:

Line 3079: FROM gl_periods gp,

3075: gp.start_date
3076: INTO l_period_set_name,
3077: l_period_name,
3078: l_period_start_date
3079: FROM gl_periods gp,
3080: gl_sets_of_books gsob,
3081: /*org_organization_definitions ood */
3082: cst_organization_definitions ood
3083: WHERE ood.organization_id = l_organization_id

Line 5267: from gl_periods y,

5263: select
5264: y.start_date
5265: into
5266: l_period_start_date
5267: from gl_periods y,
5268: mfg_lookups x
5269: where
5270: y.adjustment_period_flag = 'N' and
5271: x.lookup_type(+) = 'MTL_ACCT_PERIOD_STATUS' and

Line 5288: from gl_periods y,

5284: select
5285: y.end_date
5286: into
5287: l_period_end_date
5288: from gl_periods y,
5289: mfg_lookups x
5290: where
5291: y.adjustment_period_flag = 'N' and
5292: x.lookup_type(+) = 'MTL_ACCT_PERIOD_STATUS' and