APPS.ARP_TRX_VAL dependencies on AR_RECEIPT_CLASSES

Line 360: ar_receipt_classes arc

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:
364: receipt_creation_method_rec receipt_creation_method_cur%ROWTYPE;

Line 396: ar_receipt_classes arc

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)
400: AND NVL(arm.end_date,p_trx_date)

Line 442: ar_receipt_classes arc,

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,
443: ce_bank_branches_v bp
444: WHERE arm.receipt_method_id = arma.receipt_method_id
445: AND arm.receipt_class_id = arc.receipt_class_id
446: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id