DBA Data[Home] [Help]

APPS.BOM_CSTRDACR_XMLP_PKG dependencies on ORG_ACCT_PERIODS

Line 28: ORG_ACCT_PERIODS OAP1,

24: OAP1.PERIOD_START_DATE,
25: OAP2.SCHEDULE_CLOSE_DATE
26: INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
27: FROM
28: ORG_ACCT_PERIODS OAP1,
29: ORG_ACCT_PERIODS OAP2
30: WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
31: AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
32: AND OAP2.ORGANIZATION_ID = P_ORG_ID

Line 29: ORG_ACCT_PERIODS OAP2

25: OAP2.SCHEDULE_CLOSE_DATE
26: INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
27: FROM
28: ORG_ACCT_PERIODS OAP1,
29: ORG_ACCT_PERIODS OAP2
30: WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
31: AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
32: AND OAP2.ORGANIZATION_ID = P_ORG_ID
33: AND OAP2.ACCT_PERIOD_ID = P_PERIOD_ID_TO;