DBA Data[Home] [Help]

APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on AP_ACCT_CLASS_CODE_GT

Line 133: l_debug_info := 'Populate AP_ACCT_CLASS_CODE_GT';

129: AND XACA.assignment_owner_code = XAD.assignment_owner_code
130: AND XAD.ledger_id = P_ledger_id
131: AND XAD.enabled_flag = 'Y';
132: --
133: l_debug_info := 'Populate AP_ACCT_CLASS_CODE_GT';
134: --
135: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
137: END IF;

Line 142: INSERT INTO AP_ACCT_CLASS_CODE_GT (

138: --
139: IF acct_class_code_rec.l_acct_class_code_t.COUNT > 0 THEN
140: --
141: FOR i IN 1..acct_class_code_rec.l_acct_class_code_t.LAST LOOP
142: INSERT INTO AP_ACCT_CLASS_CODE_GT (
143: accounting_class_code)
144: VALUES(acct_class_code_rec.l_acct_class_code_t(i));
145: END LOOP;
146: --

Line 149: INSERT INTO AP_ACCT_CLASS_CODE_GT (

145: END LOOP;
146: --
147: ELSE
148:
149: INSERT INTO AP_ACCT_CLASS_CODE_GT (
150: accounting_class_code)
151: SELECT XACA.accounting_class_code
152: FROM xla_acct_class_assgns XACA,
153: xla_assignment_defns_b XAD,

Line 627: ap_acct_class_code_gt AAGT

623: xla_distribution_links XDL,
624: xla_ae_headers XAH,
625: xla_ae_lines XAL,
626: ap_alc_ledger_gt ALGT,
627: ap_acct_class_code_gt AAGT
628: WHERE APIDG.po_distribution_id = POD.po_distribution_id(+)
629: AND API.invoice_id = APIL.invoice_id
630: AND APIL.invoice_id = APIDG.invoice_id
631: AND APIL.line_number = APIDG.invoice_line_number

Line 1029: ap_acct_class_code_gt AAGT

1025: xla_distribution_links XDL,
1026: xla_ae_headers XAH,
1027: xla_ae_lines XAL,
1028: ap_alc_ledger_gt ALGT,
1029: ap_acct_class_code_gt AAGT
1030: WHERE APIDG.po_distribution_id = POD.po_distribution_id(+)
1031: AND API.invoice_id = APIL.invoice_id
1032: AND APIL.invoice_id = APIDG.invoice_id
1033: AND APIL.line_number = APIDG.invoice_line_number

Line 1428: ap_acct_class_code_gt AAGT

1424: xla_distribution_links XDL,
1425: xla_ae_headers XAH,
1426: xla_ae_lines XAL,
1427: ap_alc_ledger_gt ALGT,
1428: ap_acct_class_code_gt AAGT
1429: WHERE APIP.invoice_payment_id = l_invoice_pay_id
1430: AND APIP.invoice_payment_id = APHD.invoice_payment_id
1431: AND APHD.invoice_distribution_id = APID.invoice_distribution_id
1432: AND APHD.pay_dist_lookup_code = 'DISCOUNT'