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 1610: ar_receivables_trx ed,

1606: p_rule_rec.liability_tax_code2 ,
1607: p_rule_rec.act_tax_non_rec_ccid2 ,
1608: p_rule_rec.act_vat_tax_id2
1609: from ar_receipt_method_accounts rma,
1610: ar_receivables_trx ed,
1611: ar_rec_trx_le_details edd,
1612: ar_receivables_trx uned,
1613: ar_rec_trx_le_details unedd
1614: where rma.receipt_method_id = p_cr_rec.receipt_method_id

Line 1612: ar_receivables_trx uned,

1608: p_rule_rec.act_vat_tax_id2
1609: from ar_receipt_method_accounts rma,
1610: ar_receivables_trx ed,
1611: ar_rec_trx_le_details edd,
1612: ar_receivables_trx uned,
1613: ar_rec_trx_le_details unedd
1614: where rma.receipt_method_id = p_cr_rec.receipt_method_id
1615: and rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1616: and rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)

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

1620: and uned.receivables_trx_id = unedd.receivables_trx_id (+)
1621: and unedd.legal_entity_id (+) = l_le_id;
1622:
1623: ELSE
1624: /* OU is in use, reference ar_receivables_trx directly */
1625:
1626: select nvl(ed.gl_account_source,'NO_SOURCE') ,
1627: nvl(ed.tax_code_source,'NO_SOURCE') ,
1628: ed.tax_recoverable_flag ,

Line 1659: ar_receivables_trx ed,

1655: p_rule_rec.liability_tax_code2 ,
1656: p_rule_rec.act_tax_non_rec_ccid2 ,
1657: p_rule_rec.act_vat_tax_id2
1658: from ar_receipt_method_accounts rma,
1659: ar_receivables_trx ed,
1660: ar_receivables_trx uned
1661: where rma.receipt_method_id = p_cr_rec.receipt_method_id
1662: and rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1663: and rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)

Line 1660: ar_receivables_trx uned

1656: p_rule_rec.act_tax_non_rec_ccid2 ,
1657: p_rule_rec.act_vat_tax_id2
1658: from ar_receipt_method_accounts rma,
1659: ar_receivables_trx ed,
1660: ar_receivables_trx uned
1661: where rma.receipt_method_id = p_cr_rec.receipt_method_id
1662: and rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1663: and rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)
1664: and rma.unedisc_receivables_trx_id = uned.receivables_trx_id (+) ;

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

1802: PROCEDURE Act_Tax_Non_Rec_Ccid (
1803: p_type IN VARCHAR2 ,
1804: p_asset_tax_code IN VARCHAR2 ,
1805: p_apply_date IN DATE ,
1806: p_act_tax_non_rec_ccid OUT NOCOPY ar_receivables_trx.code_combination_id%TYPE ,
1807: p_act_vat_tax_id OUT NOCOPY ar_vat_tax.vat_tax_id%TYPE ) IS
1808:
1809: BEGIN
1810: