APPS.ARP_LOCKBOX_HOOK_PVT dependencies on AR_TRANSMISSIONS_ALL

Line 51: from ar_lockboxes_all a, ar_transmissions_all b

47: END IF;
48:
49: BEGIN
50: select nvl(a.LINE_LEVEL_CASH_APP_RULE,'N') into l_line_level_cash_app_rule
51: from ar_lockboxes_all a, ar_transmissions_all b
52: where b.transmission_request_id = in_trans_req_id
53: and a.lockbox_id = b.requested_lockbox_id;
54: EXCEPTION
55: WHEN NO_DATA_FOUND THEN

Line 466: AND record_type in ( select a.record_identifier from ar_trans_record_formats a, ar_transmissions_all b

462: amount_applied8,
463: batch_name
464: FROM ar_payments_interface_all
465: WHERE transmission_request_id = req_id
466: AND record_type in ( select a.record_identifier from ar_trans_record_formats a, ar_transmissions_all b
467: where b.transmission_request_id = req_id
468: and b.requested_trans_format_id = a.transmission_format_id
469: and a.record_type_lookup_code in ('PAYMENT','OVRFLW PAYMENT') );
470: BEGIN

Line 481: ar_transmissions_all b

477: INTO l_batches
478: FROM ar_trans_field_formats
479: WHERE transmission_format_id = (SELECT transmission_format_id
480: FROM ar_transmission_formats a,
481: ar_transmissions_all b
482: WHERE a.transmission_format_id = b.requested_trans_format_id
483: AND b.transmission_request_id = in_trans_req_id )
484: AND field_type_lookup_code = 'BATCH NAME';
485: EXCEPTION

Line 690: FROM ar_trans_field_formats a, ar_transmissions_all b

686: IF l_last_invoice_index IS NOT NULL THEN
687:
688: SELECT overflow_rec_indicator
689: INTO l_overflow_indicator
690: FROM ar_trans_field_formats a, ar_transmissions_all b
691: WHERE b.requested_trans_format_id = a.transmission_format_id
692: AND b.transmission_request_id = in_trans_req_id
693: AND a.FIELD_TYPE_LOOKUP_CODE = 'OVRFLW IND';
694:

Line 705: FROM ar_transmissions_all a,

701: SELECT b.record_identifier,
702: b.transmission_format_id,
703: a.transmission_id
704: INTO l_overflow_rec, l_trans_format_id, l_transmission_id
705: FROM ar_transmissions_all a,
706: ar_trans_record_formats b
707: WHERE a.requested_trans_format_id = b.transmission_format_id
708: AND a.transmission_request_id = in_trans_req_id
709: AND b.record_type_lookup_code = 'OVRFLW PAYMENT';

Line 1032: ar_transmissions_all b,

1028: a.currency_code,
1029: decode(format_amount1,'Y',d.precision,0)
1030: INTO l_org_id, l_lockbox_number, l_batch_name, l_currency_code, l_precision
1031: FROM ar_payments_interface_all a,
1032: ar_transmissions_all b,
1033: ar_trans_record_formats c,
1034: fnd_currencies d
1035: WHERE a.transmission_request_id = b.transmission_request_id
1036: AND b.requested_trans_format_id = c.transmission_format_id

Line 1187: from ar_trans_record_formats a, ar_transmissions_all b

1183: select count(*) from ar_payments_interface_all
1184: where transmission_request_id = in_trans_req_id )
1185: where transmission_request_id = in_trans_req_id
1186: and record_type in ( select a.record_identifier
1187: from ar_trans_record_formats a, ar_transmissions_all b
1188: where b.transmission_request_id = in_trans_req_id
1189: and b.requested_trans_format_id = a.transmission_format_id
1190: and a.record_type_lookup_code in ('TRANS HDR','TRANS TRL') );
1191: