DBA Data[Home] [Help]

APPS.BOM_CSTRACTC_XMLP_PKG dependencies on ORG_ACCT_PERIODS

Line 87: ORG_ACCT_PERIODS OAP1,

83: OAP1.PERIOD_START_DATE,
84: OAP2.SCHEDULE_CLOSE_DATE
85: INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
86: FROM
87: ORG_ACCT_PERIODS OAP1,
88: ORG_ACCT_PERIODS OAP2
89: WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
90: AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
91: AND OAP2.ORGANIZATION_ID = P_ORG_ID

Line 88: ORG_ACCT_PERIODS OAP2

84: OAP2.SCHEDULE_CLOSE_DATE
85: INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
86: FROM
87: ORG_ACCT_PERIODS OAP1,
88: ORG_ACCT_PERIODS OAP2
89: WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
90: AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
91: AND OAP2.ORGANIZATION_ID = P_ORG_ID
92: AND OAP2.ACCT_PERIOD_ID = P_PERIOD_ID_TO;