APPS.CSTACPCS dependencies on ORG_ACCT_PERIODS

Line 43: ORG_ACCT_PERIODS OAP

39: MMT.SUBINVENTORY_CODE
40: FROM
41: MTL_PER_CLOSE_DTLS MPSD ,
42: MTL_MATERIAL_TRANSACTIONS MMT,
43: ORG_ACCT_PERIODS OAP
44: WHERE
45: MPSD.ACCT_PERIOD_ID = C_ACCT_PERIOD_ID AND
46: MPSD.ORGANIZATION_ID = C_ORG_ID AND
47: MMT.COST_GROUP_ID = MPSD.COST_GROUP_ID AND

Line 172: ORG_ACCT_PERIODS

168: SELECT
169: SCHEDULE_CLOSE_DATE
170: INTO l_acct_close_date
171: FROM
172: ORG_ACCT_PERIODS
173: WHERE
174: ORGANIZATION_ID = I_ORG_ID AND
175: ACCT_PERIOD_ID = I_ACCT_PERIOD_ID;
176: /*End of Addition for 1478959 in 11.0 .... Porting the changes to 11.5 Bug 1521581*/

Line 422: ORG_ACCT_PERIODS

418: SELECT
419: SCHEDULE_CLOSE_DATE
420: INTO l_last_close_date
421: FROM
422: ORG_ACCT_PERIODS
423: WHERE
424: ORGANIZATION_ID = I_ORG_ID AND
425: ACCT_PERIOD_ID = I_LAST_PERIOD_ID;
426: