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 481: AND record_type in ( select a.record_identifier from ar_trans_record_formats a, ar_transmissions_all b

477: amount_applied8,
478: batch_name
479: FROM ar_payments_interface_all
480: WHERE transmission_request_id = req_id
481: AND record_type in ( select a.record_identifier from ar_trans_record_formats a, ar_transmissions_all b
482: where b.transmission_request_id = req_id
483: and b.requested_trans_format_id = a.transmission_format_id
484: and a.record_type_lookup_code in ('PAYMENT','OVRFLW PAYMENT') );
485: BEGIN

Line 496: ar_transmissions_all b

492: INTO l_batches
493: FROM ar_trans_field_formats
494: WHERE transmission_format_id = (SELECT transmission_format_id
495: FROM ar_transmission_formats a,
496: ar_transmissions_all b
497: WHERE a.transmission_format_id = b.requested_trans_format_id
498: AND b.transmission_request_id = in_trans_req_id )
499: AND field_type_lookup_code = 'BATCH NAME';
500: EXCEPTION

Line 705: FROM ar_trans_field_formats a, ar_transmissions_all b

701: IF l_last_invoice_index IS NOT NULL THEN
702:
703: SELECT overflow_rec_indicator
704: INTO l_overflow_indicator
705: FROM ar_trans_field_formats a, ar_transmissions_all b
706: WHERE b.requested_trans_format_id = a.transmission_format_id
707: AND b.transmission_request_id = in_trans_req_id
708: AND a.FIELD_TYPE_LOOKUP_CODE = 'OVRFLW IND';
709:

Line 720: FROM ar_transmissions_all a,

716: SELECT b.record_identifier,
717: b.transmission_format_id,
718: a.transmission_id
719: INTO l_overflow_rec, l_trans_format_id, l_transmission_id
720: FROM ar_transmissions_all a,
721: ar_trans_record_formats b
722: WHERE a.requested_trans_format_id = b.transmission_format_id
723: AND a.transmission_request_id = in_trans_req_id
724: AND b.record_type_lookup_code = 'OVRFLW PAYMENT';

Line 1077: ar_transmissions_all b,

1073: a.currency_code,
1074: decode(format_amount1,'Y',d.precision,0)
1075: INTO l_org_id, l_lockbox_number, l_batch_name, l_currency_code, l_precision
1076: FROM ar_payments_interface_all a,
1077: ar_transmissions_all b,
1078: ar_trans_record_formats c,
1079: fnd_currencies d
1080: WHERE a.transmission_request_id = b.transmission_request_id
1081: AND b.requested_trans_format_id = c.transmission_format_id

Line 1234: from ar_trans_record_formats a, ar_transmissions_all b

1230: select count(*) from ar_payments_interface_all
1231: where transmission_request_id = in_trans_req_id )
1232: where transmission_request_id = in_trans_req_id
1233: and record_type in ( select a.record_identifier
1234: from ar_trans_record_formats a, ar_transmissions_all b
1235: where b.transmission_request_id = in_trans_req_id
1236: and b.requested_trans_format_id = a.transmission_format_id
1237: and a.record_type_lookup_code in ('TRANS HDR','TRANS TRL') );
1238: