[Home] [Help]
1055: -- |-- Check Entity Type is eAM
1056: -- |-- Get charge asset using API
1057: -- |-- Get the period set name and period name
1058: -- | |-- if scheduled date is in current PAC period use CST_PAC_PERIODS
1059: -- | |-- else if its in a future period use GL_PERIODS
1060: -- | End IF
1061: -- |-- Derive the currency extended precision for the organization
1062: -- |-- Derive valuation rates cost type based on organization's cost method
1063: -- |-- For Resources, open c_wor cursor LOOP
1663: AND cpp.period_end_date;
1664:
1665: l_stmt_num := 230;
1666:
1667: ELSE -- Get period info from Gl_periods, if completion date is in future period
1668:
1669: l_stmt_num := 232;
1670:
1671: /* The following query will be modified to refer to
1674: SELECT gp.period_set_name, gp.period_name,
1675: gp.start_date
1676: INTO l_period_set_name, l_period_name,
1677: l_period_start_date
1678: FROM gl_periods gp,
1679: gl_sets_of_books gsob,
1680: cst_organization_definitions ood
1681: WHERE ood.organization_id = l_organization_id
1682: AND gsob.set_of_books_id = ood.set_of_books_id
3014: WHEN NO_DATA_FOUND THEN -- no open period
3015: l_open_period := FND_API.G_FALSE;
3016: END;
3017:
3018: -- Get data from gl_periods if it is a future period.
3019: IF NOT FND_API.to_boolean(l_open_period) THEN
3020: l_stmt_num := 410;
3021:
3022: l_period_set_name := p_period_set_name;
3029: INTO l_period_id,
3030: l_period_set_name,
3031: l_period_name,
3032: l_period_start_date
3033: FROM gl_periods
3034: WHERE period_set_name = l_period_set_name
3035: AND period_name = l_period_name;
3036: END IF;
3037: