APPS.WIP_CHANGE_STATUS dependencies on ORG_ACCT_PERIODS

Line 112: FROM ORG_ACCT_PERIODS OAP,

108: SYSDATE, X_user_id, X_login_id,
109: P_organization_id, WC.CLASS_TYPE,
110: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
111: 0, 0, 0, 0, 0, 0, 0, 0
112: FROM ORG_ACCT_PERIODS OAP,
113: WIP_ACCOUNTING_CLASSES WC
114: WHERE WC.CLASS_CODE = P_class_code
115: AND WC.ORGANIZATION_ID = P_organization_id
116: AND OAP.ORGANIZATION_ID = P_organization_id

Line 159: FROM ORG_ACCT_PERIODS OAP,

155: SYSDATE, X_user_id, X_login_id,
156: P_organization_id, WC.CLASS_TYPE,
157: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
158: 0, 0, 0, 0, 0, 0, 0, 0
159: FROM ORG_ACCT_PERIODS OAP,
160: WIP_ACCOUNTING_CLASSES WC
161: WHERE WC.CLASS_CODE = P_class_code
162: AND WC.ORGANIZATION_ID = P_organization_id
163: AND OAP.ORGANIZATION_ID = P_organization_id

Line 209: FROM ORG_ACCT_PERIODS

205: ELSE
206: DECLARE
207: CURSOR C1 IS
208: SELECT 'x'
209: FROM ORG_ACCT_PERIODS
210: WHERE ORGANIZATION_ID = P_Organization_Id
211: AND TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(
212: P_RELEASE_DATE,P_Organization_Id))
213: BETWEEN PERIOD_START_DATE AND SCHEDULE_CLOSE_DATE