DBA Data[Home] [Help]

APPS.ARP_RECEIPTS_MAIN dependencies on AR_RECEIVABLES_TRX

Line 67: p_act_tax_non_rec_ccid OUT NOCOPY ar_receivables_trx.code_combination_id%TYPE ,

63: PROCEDURE Act_Tax_Non_Rec_Ccid (
64: p_type IN VARCHAR2 ,
65: p_asset_tax_code IN VARCHAR2 ,
66: p_apply_date IN DATE ,
67: p_act_tax_non_rec_ccid OUT NOCOPY ar_receivables_trx.code_combination_id%TYPE ,
68: p_act_vat_tax_id OUT NOCOPY ar_vat_tax.vat_tax_id%TYPE );
69:
70: PROCEDURE Create_Ae_Lines_Common (
71: p_level IN VARCHAR2,

Line 1537: ar_receivables_trx ed,

1533: p_rule_rec.liability_tax_code2 ,
1534: p_rule_rec.act_tax_non_rec_ccid2 ,
1535: p_rule_rec.act_vat_tax_id2
1536: from ar_receipt_method_accounts rma,
1537: ar_receivables_trx ed,
1538: ar_rec_trx_le_details edd,
1539: ar_receivables_trx uned,
1540: ar_rec_trx_le_details unedd
1541: where rma.receipt_method_id = p_cr_rec.receipt_method_id

Line 1539: ar_receivables_trx uned,

1535: p_rule_rec.act_vat_tax_id2
1536: from ar_receipt_method_accounts rma,
1537: ar_receivables_trx ed,
1538: ar_rec_trx_le_details edd,
1539: ar_receivables_trx uned,
1540: ar_rec_trx_le_details unedd
1541: where rma.receipt_method_id = p_cr_rec.receipt_method_id
1542: and rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1543: and rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)

Line 1551: /* OU is in use, reference ar_receivables_trx directly */

1547: and uned.receivables_trx_id = unedd.receivables_trx_id (+)
1548: and unedd.legal_entity_id (+) = l_le_id;
1549:
1550: ELSE
1551: /* OU is in use, reference ar_receivables_trx directly */
1552:
1553: select nvl(ed.gl_account_source,'NO_SOURCE') ,
1554: nvl(ed.tax_code_source,'NO_SOURCE') ,
1555: ed.tax_recoverable_flag ,

Line 1586: ar_receivables_trx ed,

1582: p_rule_rec.liability_tax_code2 ,
1583: p_rule_rec.act_tax_non_rec_ccid2 ,
1584: p_rule_rec.act_vat_tax_id2
1585: from ar_receipt_method_accounts rma,
1586: ar_receivables_trx ed,
1587: ar_receivables_trx uned
1588: where rma.receipt_method_id = p_cr_rec.receipt_method_id
1589: and rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1590: and rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)

Line 1587: ar_receivables_trx uned

1583: p_rule_rec.act_tax_non_rec_ccid2 ,
1584: p_rule_rec.act_vat_tax_id2
1585: from ar_receipt_method_accounts rma,
1586: ar_receivables_trx ed,
1587: ar_receivables_trx uned
1588: where rma.receipt_method_id = p_cr_rec.receipt_method_id
1589: and rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1590: and rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)
1591: and rma.unedisc_receivables_trx_id = uned.receivables_trx_id (+) ;

Line 1733: p_act_tax_non_rec_ccid OUT NOCOPY ar_receivables_trx.code_combination_id%TYPE ,

1729: PROCEDURE Act_Tax_Non_Rec_Ccid (
1730: p_type IN VARCHAR2 ,
1731: p_asset_tax_code IN VARCHAR2 ,
1732: p_apply_date IN DATE ,
1733: p_act_tax_non_rec_ccid OUT NOCOPY ar_receivables_trx.code_combination_id%TYPE ,
1734: p_act_vat_tax_id OUT NOCOPY ar_vat_tax.vat_tax_id%TYPE ) IS
1735:
1736: BEGIN
1737: