APPS.AR_RECEIPT_LIB_PVT dependencies on AR_RECEIVABLES_TRX

Line 629: from ar_receivables_trx

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

Line 1473: ar_receivables_trx art1, ar_receivables_trx art2

1469: l_unapplied_ccid,l_unearned_ccid,l_unidentified_ccid,
1470: l_bank_charges_ccid,l_factor_ccid,l_remittance_ccid,
1471: l_receipt_clearing_ccid,l_short_term_debt_ccid
1472: FROM ar_receipt_method_accounts rma,
1473: ar_receivables_trx art1, ar_receivables_trx art2
1474: WHERE remit_bank_acct_use_id = p_remittance_bank_account_id
1475: AND receipt_method_id = p_receipt_method_id
1476: AND art1.receivables_trx_id = rma.edisc_receivables_trx_id
1477: AND art2.receivables_trx_id = rma.unedisc_receivables_trx_id;

Line 7376: l_source_code ar_receivables_trx.gl_account_source%type;

7372: l_zx_return_status VARCHAR2(10);
7373: l_tax_class VARCHAR2(20);
7374:
7375: /*Bug 5598297 */
7376: l_source_code ar_receivables_trx.gl_account_source%type;
7377: l_dist_set_id ar_receivables_trx.default_acctg_distribution_set%type;
7378:
7379: CURSOR get_dist_ccid(p_dist_id NUMBER) IS
7380: SELECT dist_code_combination_id

Line 7377: l_dist_set_id ar_receivables_trx.default_acctg_distribution_set%type;

7373: l_tax_class VARCHAR2(20);
7374:
7375: /*Bug 5598297 */
7376: l_source_code ar_receivables_trx.gl_account_source%type;
7377: l_dist_set_id ar_receivables_trx.default_acctg_distribution_set%type;
7378:
7379: CURSOR get_dist_ccid(p_dist_id NUMBER) IS
7380: SELECT dist_code_combination_id
7381: FROM ar_distribution_set_lines

Line 7519: FROM ar_receivables_trx rt,

7515:
7516: /* 5236782 - made details not required for misc receipts */
7517: SELECT vat.tax_rate_id
7518: INTO p_vat_tax_id
7519: FROM ar_receivables_trx rt,
7520: ar_rec_trx_le_details details,
7521: zx_sco_rates vat
7522: WHERE rt.receivables_trx_id = p_receivables_trx_id
7523: AND rt.receivables_trx_id = details.receivables_trx_id (+)

Line 7550: FROM ar_receivables_trx rt,

7546: ELSE
7547: BEGIN
7548: SELECT vat.tax_rate_id
7549: INTO p_vat_tax_id
7550: FROM ar_receivables_trx rt,
7551: zx_sco_rates vat
7552: WHERE rt.receivables_trx_id = p_receivables_trx_id
7553: AND rt.type in ('MISCCASH', 'BANK_ERROR')
7554: AND nvl(rt.status, 'A') = 'A'

Line 7582: from ar_receivables_trx

7578: IF p_distribution_set_id is NULL THEN
7579: Begin
7580: select gl_account_source,default_acctg_distribution_set into
7581: l_source_code, l_dist_set_id
7582: from ar_receivables_trx
7583: where receivables_trx_id = nvl(p_receivables_trx_id,-99);
7584: IF l_source_code = 'DISTRIBUTION_SET' THEN
7585: p_distribution_set_id := l_dist_set_id;
7586: ELSE

Line 7599: from ar_receivables_trx

7595: IF p_distribution_set_id IS NULL THEN
7596: BEGIN
7597: select code_combination_id
7598: into l_code_combination_id
7599: from ar_receivables_trx
7600: where receivables_trx_id=p_receivables_trx_id;
7601:
7602: l_message := 'AR_ACT_GL_ACC_ASSGN';
7603: validate_cc_segments(l_code_combination_id,

Line 7902: FROM ar_receivables_trx rt

7898:
7899: BEGIN
7900: SELECT rt.receivables_trx_id
7901: INTO p_receivable_trx_id
7902: FROM ar_receivables_trx rt
7903: WHERE nvl(rt.status,'A') = 'A'
7904: AND trunc(sysdate) between nvl(rt.start_date_active,trunc(sysdate))
7905: and nvl(rt.end_date_active,trunc(sysdate))
7906: AND rt.type = p_appl_type