DBA Data[Home] [Help]

APPS.ARP_TRX_VAL dependencies on AR_RECEIPT_METHODS

Line 359: FROM ar_receipt_methods arm,

355:
356: IS
357: CURSOR receipt_creation_method_cur IS
358: SELECT arc.creation_method_code
359: FROM ar_receipt_methods arm,
360: ar_receipt_classes arc
361: WHERE arm.receipt_class_id = arc.receipt_class_id
362: AND arm.receipt_method_id = p_receipt_method_id;
363:

Line 395: FROM ar_receipt_methods arm,

391: only*/
392:
393: SELECT 'invalid_payment method'
394: INTO l_temp
395: FROM ar_receipt_methods arm,
396: ar_receipt_classes arc
397: WHERE arm.receipt_method_id = p_receipt_method_id
398: AND arm.receipt_class_id = arc.receipt_class_id
399: AND p_trx_date BETWEEN NVL(arm.start_date,p_trx_date)

Line 438: FROM ar_receipt_methods arm,

434: l_pay_to_party_id := arp_trx_defaults_3.get_party_id(p_pay_to_customer_id);
435:
436: SELECT 'invalid_payment method'
437: INTO l_temp
438: FROM ar_receipt_methods arm,
439: ar_receipt_method_accounts arma,
440: ce_bank_accounts cba,
441: ce_bank_acct_uses aba,
442: ar_receipt_classes arc,