APPS.AR_RECEIPT_LIB_PVT dependencies on AR_RECEIVABLES_TRX

Line 626: from ar_receivables_trx

622: ELSIF (p_entity = 'RECEIVABLES_ACTIVITY' ) THEN
623: --
624: select receivables_trx_id
625: into l_selected_id
626: from ar_receivables_trx
627: where name = p_value;
628: ELSIF (p_entity = 'TAX_CODE' ) THEN
629: --
630: -- ETAX replaced reference of obsoleted ar vat tax

Line 1466: ar_receivables_trx art1, ar_receivables_trx art2

1462: l_unapplied_ccid,l_unearned_ccid,l_unidentified_ccid,
1463: l_bank_charges_ccid,l_factor_ccid,l_remittance_ccid,
1464: l_receipt_clearing_ccid,l_short_term_debt_ccid
1465: FROM ar_receipt_method_accounts rma,
1466: ar_receivables_trx art1, ar_receivables_trx art2
1467: WHERE remit_bank_acct_use_id = p_remittance_bank_account_id
1468: AND receipt_method_id = p_receipt_method_id
1469: AND art1.receivables_trx_id = rma.edisc_receivables_trx_id
1470: AND art2.receivables_trx_id = rma.unedisc_receivables_trx_id;

Line 7087: l_source_code ar_receivables_trx.gl_account_source%type;

7083: l_zx_effective_date DATE;
7084: l_zx_return_status VARCHAR2(10);
7085:
7086: /*Bug 5598297 */
7087: l_source_code ar_receivables_trx.gl_account_source%type;
7088: l_dist_set_id ar_receivables_trx.default_acctg_distribution_set%type;
7089:
7090: CURSOR get_dist_ccid(p_dist_id NUMBER) IS
7091: SELECT dist_code_combination_id

Line 7088: l_dist_set_id ar_receivables_trx.default_acctg_distribution_set%type;

7084: l_zx_return_status VARCHAR2(10);
7085:
7086: /*Bug 5598297 */
7087: l_source_code ar_receivables_trx.gl_account_source%type;
7088: l_dist_set_id ar_receivables_trx.default_acctg_distribution_set%type;
7089:
7090: CURSOR get_dist_ccid(p_dist_id NUMBER) IS
7091: SELECT dist_code_combination_id
7092: FROM ar_distribution_set_lines

Line 7223: FROM ar_receivables_trx rt,

7219: BEGIN
7220: /* 5236782 - made details not required for misc receipts */
7221: SELECT vat.tax_rate_id
7222: INTO p_vat_tax_id
7223: FROM ar_receivables_trx rt,
7224: ar_rec_trx_le_details details,
7225: zx_sco_rates vat
7226: WHERE rt.receivables_trx_id = p_receivables_trx_id
7227: AND rt.receivables_trx_id = details.receivables_trx_id (+)

Line 7253: FROM ar_receivables_trx rt,

7249: ELSE
7250: BEGIN
7251: SELECT vat.tax_rate_id
7252: INTO p_vat_tax_id
7253: FROM ar_receivables_trx rt,
7254: zx_sco_rates vat
7255: WHERE rt.receivables_trx_id = p_receivables_trx_id
7256: AND rt.type in ('MISCCASH', 'BANK_ERROR')
7257: AND nvl(rt.status, 'A') = 'A'

Line 7283: from ar_receivables_trx

7279: IF p_distribution_set_id is NULL THEN
7280: Begin
7281: select gl_account_source,default_acctg_distribution_set into
7282: l_source_code, l_dist_set_id
7283: from ar_receivables_trx
7284: where receivables_trx_id = nvl(p_receivables_trx_id,-99);
7285: IF l_source_code = 'DISTRIBUTION_SET' THEN
7286: p_distribution_set_id := l_dist_set_id;
7287: ELSE

Line 7300: from ar_receivables_trx

7296: IF p_distribution_set_id IS NULL THEN
7297: BEGIN
7298: select code_combination_id
7299: into l_code_combination_id
7300: from ar_receivables_trx
7301: where receivables_trx_id=p_receivables_trx_id;
7302:
7303: l_message := 'AR_ACT_GL_ACC_ASSGN';
7304: validate_cc_segments(l_code_combination_id,

Line 7603: FROM ar_receivables_trx rt

7599:
7600: BEGIN
7601: SELECT rt.receivables_trx_id
7602: INTO p_receivable_trx_id
7603: FROM ar_receivables_trx rt
7604: WHERE nvl(rt.status,'A') = 'A'
7605: AND trunc(sysdate) between nvl(rt.start_date_active,trunc(sysdate))
7606: and nvl(rt.end_date_active,trunc(sysdate))
7607: AND rt.type = p_appl_type