APPS.CST_MGD_INFL_ADJUSTMENT_PVT dependencies on ORG_ACCT_PERIODS

Line 78: ORG_ACCT_PERIODS

74: Period_Close_Date
75: INTO
76: l_period_close_date
77: FROM
78: ORG_ACCT_PERIODS
79: WHERE Organization_ID = p_org_id
80: AND Acct_Period_ID = p_acct_period_id
81: AND Open_Flag = 'N'
82: AND Period_Close_Date IS NOT NULL;

Line 151: ORG_ACCT_PERIODS

147: INTO
148: x_prev_sch_close_date
149: , x_prev_acct_period_id
150: FROM
151: ORG_ACCT_PERIODS
152: WHERE Organization_ID = p_organization_id
153: AND Acct_Period_ID = (SELECT
154: MAX(Acct_Period_ID)
155: FROM

Line 209: FROM ORG_ACCT_PERIODS oap2

205: l_cur_org_acct_period_val NUMBER;
206: BEGIN
207: SELECT oap2.period_year * 10000 + oap2.period_num
208: INTO l_cur_org_acct_period_val
209: FROM ORG_ACCT_PERIODS oap2
210: WHERE oap2.organization_id = p_organization_id
211: AND oap2.acct_period_id = p_acct_period_id;
212:
213: SELECT oap.acct_period_id

Line 215: FROM ORG_ACCT_PERIODS oap

211: AND oap2.acct_period_id = p_acct_period_id;
212:
213: SELECT oap.acct_period_id
214: INTO l_prev_org_acct_period_id
215: FROM ORG_ACCT_PERIODS oap
216: WHERE oap.period_year * 10000 + oap.period_num =
217: (SELECT MAX(oap2.period_year * 10000 + oap2.period_num)
218: FROM ORG_ACCT_PERIODS oap2
219: WHERE oap2.organization_id = p_organization_id

Line 218: FROM ORG_ACCT_PERIODS oap2

214: INTO l_prev_org_acct_period_id
215: FROM ORG_ACCT_PERIODS oap
216: WHERE oap.period_year * 10000 + oap.period_num =
217: (SELECT MAX(oap2.period_year * 10000 + oap2.period_num)
218: FROM ORG_ACCT_PERIODS oap2
219: WHERE oap2.organization_id = p_organization_id
220: AND (oap2.period_year * 10000 + oap2.period_num) <
221: l_cur_org_acct_period_val
222: )

Line 276: ORG_ACCT_PERIODS

272: INTO
273: x_curr_period_start_date
274: , x_curr_period_end_date
275: FROM
276: ORG_ACCT_PERIODS
277: WHERE Acct_Period_ID = p_acct_period_id
278: AND Organization_ID = p_org_id;
279:
280: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 915: -- sub-query from org_acct_periods removed instead new condition

911:
912: -- ===============================================================
913: -- Bug#2949878 fix: cursor modified
914: -- transfer_cost_group_id removed
915: -- sub-query from org_acct_periods removed instead new condition
916: -- added to retrieve the corresponding transfer account period id
917: -- Bug#2912818 fix: Exclude consigned inventory transactions
918: -- nvl(mtl.owning_tp_type,2) <> 1 added
919: -- ===============================================================

Line 928: , ORG_ACCT_PERIODS ORG

924: , NVL(Primary_Quantity, 0) Transfer_In_Qty
925: , ORG.Acct_Period_ID TNSF_Acct_Period_ID
926: FROM
927: MTL_MATERIAL_TRANSACTIONS MTL
928: , ORG_ACCT_PERIODS ORG
929: WHERE MTL.Organization_ID = p_inflation_adjustment_rec.organization_id
930: AND MTL.Inventory_Item_ID = p_inflation_adjustment_rec.inventory_item_id
931: AND MTL.Acct_Period_ID = p_inflation_adjustment_rec.acct_period_id
932: AND MTL.Primary_Quantity > 0