APPS.XLA_XLAABACR_XMLP_PKG dependencies on XLA_GL_LEDGERS_V

Line 63: XLA_GL_LEDGERS_V LE,

59: PRB.PRODUCT_RULE_TYPE_CODE,
60: PRB.PRODUCT_RULE_CODE
61: FROM
62: XLA_PRODUCT_RULES_B PRB,
63: XLA_GL_LEDGERS_V LE,
64: XLA_ACCTG_METHOD_RULES AMR,
65: XLA_LEDGER_RELATIONSHIPS_V LR
66: WHERE PRB.PRODUCT_RULE_TYPE_CODE = AMR.PRODUCT_RULE_TYPE_CODE
67: AND PRB.PRODUCT_RULE_CODE = AMR.PRODUCT_RULE_CODE

Line 91: XLA_GL_LEDGERS_V LE,

87: PRB.PRODUCT_RULE_TYPE_CODE,
88: PRB.PRODUCT_RULE_CODE
89: FROM
90: XLA_PRODUCT_RULES_B PRB,
91: XLA_GL_LEDGERS_V LE,
92: XLA_ACCTG_METHOD_RULES AMR
93: WHERE PRB.PRODUCT_RULE_TYPE_CODE = AMR.PRODUCT_RULE_TYPE_CODE
94: AND PRB.PRODUCT_RULE_CODE = AMR.PRODUCT_RULE_CODE
95: AND PRB.APPLICATION_ID = AMR.APPLICATION_ID

Line 396: XLA_GL_LEDGERS_V

392: CURSOR C_LEDGER IS
393: SELECT
394: LEDGER_CATEGORY_CODE
395: FROM
396: XLA_GL_LEDGERS_V
397: WHERE LEDGER_ID = P_LEDGER_ID;
398: BEGIN
399: XLA_UTILITY_PKG.TRACE('> XLA_XLAABACR_XMLP_PKG.set_report_constants'
400: ,20);

Line 617: CP_AAD_WHERE := ' ,xla_gl_ledgers_v le, xla_acctg_method_rules amr, xla_ledger_relationships_v lr ';

613: INTO
614: CP_LEDGER_CATEGORY;
615: CLOSE C_LEDGER;
616: IF (CP_LEDGER_CATEGORY = 'PRIMARY') THEN
617: CP_AAD_WHERE := ' ,xla_gl_ledgers_v le, xla_acctg_method_rules amr, xla_ledger_relationships_v lr ';
618: CP_AAD_QUERY := CP_AAD_QUERY || '
619: and prb.product_rule_type_code = amr.product_rule_type_code
620: and prb.product_rule_code = amr.product_rule_code
621: and prb.application_id = amr.application_id

Line 627: CP_AAD_WHERE := ' ,xla_gl_ledgers_v le,xla_acctg_method_rules amr ';

623: and amr.accounting_method_code = le.sla_accounting_method_code
624: and le.ledger_id = lr.ledger_id
625: and lr.primary_ledger_id = ' || P_LEDGER_ID;
626: ELSE
627: CP_AAD_WHERE := ' ,xla_gl_ledgers_v le,xla_acctg_method_rules amr ';
628: CP_AAD_QUERY := CP_AAD_QUERY || '
629: and prb.product_rule_type_code = amr.product_rule_type_code
630: and prb.product_rule_code = amr.product_rule_code
631: and prb.application_id = amr.application_id