[Home] [Help]
1054: -- Flow:
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
1635: l_stmt_num := 220;
1636:
1637: SELECT count(*)
1638: INTO l_dummy
1639: FROM cst_pac_periods cpp
1640: WHERE cpp.pac_period_id = p_period_id
1641: AND LEGAL_ENTITY = p_legal_entity_id
1642: AND COST_TYPE_ID = p_cost_type_id
1643: AND l_trunc_le_sched_comp_date BETWEEN cpp.PERIOD_START_DATE
1656: INTO l_acct_period_id,
1657: l_period_set_name,
1658: l_period_name,
1659: l_period_start_date
1660: FROM CST_PAC_periods cpp
1661: WHERE cpp.pac_period_id = p_period_id
1662: AND l_trunc_le_sched_comp_date BETWEEN cpp.period_start_date
1663: AND cpp.period_end_date;
1664:
1719: Pac Cost type and Cost group. Now Populate prior Period ID */
1720:
1721: SELECT NVL(MAX(cpp.pac_period_id), -1)
1722: INTO l_prior_period_id
1723: FROM cst_pac_periods cpp
1724: WHERE cpp.cost_type_id = p_cost_type_id
1725: AND cpp.legal_entity = p_legal_entity_id
1726: AND cpp.pac_period_id < p_period_id;
1727:
3003: INTO l_period_id,
3004: l_period_set_name,
3005: l_period_name,
3006: l_period_start_date
3007: FROM CST_PAC_PERIODS
3008: WHERE cost_type_id = p_cost_type_id
3009: AND legal_entity = p_legal_entity_id
3010: AND (pac_period_id = p_period_id
3011: OR (period_set_name = p_period_set_name
3828: cpp.period_name
3829: INTO l_pac_period_id,
3830: l_period_set_name,
3831: l_period_name
3832: FROM CST_PAC_periods cpp
3833: WHERE cpp.pac_period_id = p_pac_period_id;
3834:
3835: -- statement level logging
3836: IF (l_sLog) THEN