DBA Data[Home] [Help]

APPS.BOM_CSTRWOCR_XMLP_PKG dependencies on ORG_ACCT_PERIODS

Line 63: ORG_ACCT_PERIODS OAP1,

59: OAP1.PERIOD_START_DATE,
60: OAP2.SCHEDULE_CLOSE_DATE
61: INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
62: FROM
63: ORG_ACCT_PERIODS OAP1,
64: ORG_ACCT_PERIODS OAP2
65: WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
66: AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
67: AND OAP2.ORGANIZATION_ID = P_ORG_ID

Line 64: ORG_ACCT_PERIODS OAP2

60: OAP2.SCHEDULE_CLOSE_DATE
61: INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
62: FROM
63: ORG_ACCT_PERIODS OAP1,
64: ORG_ACCT_PERIODS OAP2
65: WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
66: AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
67: AND OAP2.ORGANIZATION_ID = P_ORG_ID
68: AND OAP2.ACCT_PERIOD_ID = P_PERIOD_ID_TO;