APPS.ARP_PROC_RCT_UTIL dependencies on AR_RECEIVABLES_TRX

Line 669: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;

665: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
666: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
667: ) IS
668:
669: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
670: l_distribution_set_id ar_receivables_trx.default_acctg_distribution_set%TYPE;
671: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
672: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
673: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */

Line 670: l_distribution_set_id ar_receivables_trx.default_acctg_distribution_set%TYPE;

666: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
667: ) IS
668:
669: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
670: l_distribution_set_id ar_receivables_trx.default_acctg_distribution_set%TYPE;
671: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
672: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
673: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
674: l_crh_ccid ar_cash_receipt_history.account_code_combination_id%TYPE; /*Bug fix 4025652 */

Line 675: l_type ar_receivables_trx.type%TYPE; /*4726219 */

671: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
672: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
673: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
674: l_crh_ccid ar_cash_receipt_history.account_code_combination_id%TYPE; /*Bug fix 4025652 */
675: l_type ar_receivables_trx.type%TYPE; /*4726219 */
676:
677: l_xla_ev_rec arp_xla_events.xla_events_type;
678:
679: CURSOR c_hist IS

Line 747: FROM ar_receivables_trx rt

743: rt.type
744: INTO l_trx_code_combination_id,
745: l_distribution_set_id,
746: l_type
747: FROM ar_receivables_trx rt
748: WHERE rt.type in
749: ('MISCCASH', 'BANK_ERROR', 'CCREFUND', 'CM_REFUND','CC_CHARGEBACK')
750: AND NVL( rt.status, 'A' ) = 'A'
751: AND rt.RECEIVABLES_TRX_ID = p_receivables_trx_id;

Line 921: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;

917: p_receipt_date_changed_flag IN BOOLEAN,
918: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
919: ) IS
920:
921: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
922: l_old_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
923: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
924: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
925: l_old_recs_auto_flag BOOLEAN;

Line 922: l_old_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;

918: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
919: ) IS
920:
921: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
922: l_old_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
923: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
924: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
925: l_old_recs_auto_flag BOOLEAN;
926: l_new_recs_auto_flag BOOLEAN;

Line 1100: FROM ar_receivables_trx rt

1096: /* Start Bug 6416611 - modified query to handle case of receivable activity
1097: with distribution set */
1098: SELECT rt.code_combination_id, rt.default_acctg_distribution_set
1099: INTO l_old_trx_code_combination_id, l_old_default_distribution_set
1100: FROM ar_receivables_trx rt
1101: WHERE rt.type in
1102: ('MISCCASH', 'BANK_ERROR', 'CCREFUND', 'CM_REFUND', 'CC_CHARGEBACK')
1103: -- AND ( (NVL( rt.status, 'A' ) = 'A') or (rt.end_date_active=p_receipt_date))
1104: AND rt.RECEIVABLES_TRX_ID = p_old_receivables_trx_id;

Line 1137: FROM ar_receivables_trx rt

1133: /* Start Bug 6416611 - modified query to handle case of receivable activity
1134: with distribution set */
1135: SELECT rt.code_combination_id, rt.default_acctg_distribution_set
1136: INTO l_trx_code_combination_id, l_default_distribution_set
1137: FROM ar_receivables_trx rt
1138: WHERE rt.type in
1139: ('MISCCASH', 'BANK_ERROR', 'CCREFUND', 'CM_REFUND' , 'CC_CHARGEBACK')
1140: -- AND ((NVL( rt.status, 'A' ) = 'A') or (rt.end_date_active=p_receipt_date))
1141: AND rt.RECEIVABLES_TRX_ID = p_receivables_trx_id;

Line 2105: | ar_receivables_trx instead of |

2101: | and added parameters to allow procedure to |
2102: | return all ccid's for the IN parameters |
2103: | 07-JAN-98 DJANCIS selected code combination id's for earned |
2104: | and unearnd ccids from |
2105: | ar_receivables_trx instead of |
2106: | ar_receipt_method_accounts for |
2107: | 11.5 VAT changes |
2108: | |
2109: +===========================================================================*/

Line 2128: ar_receivables_trx instead of ar_receipt_method_accounts for

2124: ) IS
2125: BEGIN
2126:
2127: /* selected code combination id's for earned and unearnd ccids from
2128: ar_receivables_trx instead of ar_receipt_method_accounts for
2129: 11.5 VAT changes */
2130:
2131: SELECT
2132: rma.unidentified_ccid,

Line 2155: AR_RECEIVABLES_TRX ed,

2151: p_remittance_ccid,
2152: p_cash_ccid
2153: FROM
2154: AR_RECEIPT_METHOD_ACCOUNTS rma,
2155: AR_RECEIVABLES_TRX ed,
2156: AR_RECEIVABLES_TRX uned
2157: WHERE remit_bank_acct_use_id = p_remittance_bank_account_id
2158: AND receipt_method_id = p_receipt_method_id
2159: AND rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)

Line 2156: AR_RECEIVABLES_TRX uned

2152: p_cash_ccid
2153: FROM
2154: AR_RECEIPT_METHOD_ACCOUNTS rma,
2155: AR_RECEIVABLES_TRX ed,
2156: AR_RECEIVABLES_TRX uned
2157: WHERE remit_bank_acct_use_id = p_remittance_bank_account_id
2158: AND receipt_method_id = p_receipt_method_id
2159: AND rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)
2160: AND rma.unedisc_receivables_trx_id = uned.receivables_trx_id (+);