DBA Data[Home] [Help]

APPS.BOM_CSTRPCRE_XMLP_PKG dependencies on ORG_ACCT_PERIODS

Line 90: ORG_ACCT_PERIODS

86: PERIOD_START_DATE,
87: SCHEDULE_CLOSE_DATE
88: INTO L_EARLIEST_TO_DATE,L_LATEST_TO_DATE
89: FROM
90: ORG_ACCT_PERIODS
91: WHERE ORGANIZATION_ID = P_ORG_ID
92: AND ACCT_PERIOD_ID = P_PERIOD_ID;
93: L_STMT_NUM := 20;
94: IF (P_TO_DATE IS NULL) THEN

Line 141: ORG_ACCT_PERIODS

137: ,L_LATEST_TO_DATE
138: ,L_P_TO_DATE)
139: INTO L_SUMMARIZED_FLAG,L_PERIOD_OPEN_FLAG,L_P_TO_DATE
140: FROM
141: ORG_ACCT_PERIODS
142: WHERE ORGANIZATION_ID = P_ORG_ID
143: AND ACCT_PERIOD_ID = P_PERIOD_ID;
144: L_STMT_NUM := 70;
145: SELECT

Line 259: ORG_ACCT_PERIODS

255: PERIOD_START_DATE,
256: PERIOD_NAME
257: INTO P_FROM_DATE,P_PERIOD_NAME
258: FROM
259: ORG_ACCT_PERIODS
260: WHERE ORGANIZATION_ID = P_ORG_ID
261: AND ACCT_PERIOD_ID = P_PERIOD_ID;
262: L_STMT_NUM := 170;
263: SELECT