APPS.WIP_CHANGE_STATUS dependencies on ORG_ACCT_PERIODS

Line 86: FROM ORG_ACCT_PERIODS OAP,

82: SYSDATE, X_user_id, X_login_id,
83: P_organization_id, WC.CLASS_TYPE,
84: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
85: 0, 0, 0, 0, 0, 0, 0, 0
86: FROM ORG_ACCT_PERIODS OAP,
87: WIP_ACCOUNTING_CLASSES WC
88: WHERE WC.CLASS_CODE = P_class_code
89: AND WC.ORGANIZATION_ID = P_organization_id
90: AND OAP.ORGANIZATION_ID = P_organization_id

Line 127: FROM ORG_ACCT_PERIODS OAP,

123: SYSDATE, X_user_id, X_login_id,
124: P_organization_id, WC.CLASS_TYPE,
125: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
126: 0, 0, 0, 0, 0, 0, 0, 0
127: FROM ORG_ACCT_PERIODS OAP,
128: WIP_ACCOUNTING_CLASSES WC
129: WHERE WC.CLASS_CODE = P_class_code
130: AND WC.ORGANIZATION_ID = P_organization_id
131: AND OAP.ORGANIZATION_ID = P_organization_id

Line 168: FROM ORG_ACCT_PERIODS

164: ELSE
165: DECLARE
166: CURSOR C1 IS
167: SELECT 'x'
168: FROM ORG_ACCT_PERIODS
169: WHERE ORGANIZATION_ID = P_Organization_Id
170: AND TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(
171: P_RELEASE_DATE,P_Organization_Id))
172: BETWEEN PERIOD_START_DATE AND SCHEDULE_CLOSE_DATE