DBA Data[Home] [Help]

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on XLA_ANALYTICAL_DTLS_B

Line 1462: XLA_ANALYTICAL_DTLS_B XADB

1458: SELECT 'PA' PROJECT_SOURCE_FLAG,
1459: SAM.CONTEXT_CODE PROJECT_AC_CODE,
1460: XADB.GROUPING_ORDER AC_GROUPING_ORDER
1461: FROM JA_CN_SUB_ACC_MAPPING SAM,
1462: XLA_ANALYTICAL_DTLS_B XADB
1463: WHERE XADB.ANALYTICAL_CRITERION_CODE = SAM.CONTEXT_CODE
1464: AND SAM.SOURCES_CODE = 'PROJECT MODULE'
1465: AND SAM.CHART_OF_ACCOUNTS_ID = l_Chart_Of_Accounts_Id;
1466:

Line 1513: FROM XLA_ANALYTICAL_DTLS_B XADB

1509: BEGIN
1510:
1511: SELECT XADB.GROUPING_ORDER
1512: INTO l_SM_Grouping_Order
1513: FROM XLA_ANALYTICAL_DTLS_B XADB
1514: WHERE XADB.ANALYTICAL_CRITERION_CODE = 'SETTLEMENT METHOD';
1515:
1516: EXCEPTION
1517: WHEN OTHERS THEN

Line 1597: -- FROM Xla_Analytical_Dtls_b Dtl

1593:
1594: --deleted for bug 6669665
1595: -- SELECT Dtl.Grouping_Order
1596: -- INTO l_Grouping_Order
1597: -- FROM Xla_Analytical_Dtls_b Dtl
1598: -- WHERE Dtl.Analytical_Criterion_Code = l_Project_Ac_Code
1599: -- AND Dtl.Analytical_Detail_Code = l_Project_Ac_Detail_Code;
1600:
1601: l_sql:='INSERT INTO Ja_Cn_Journal_Lines_Req';