APPS.ARP_LOCKBOX_HOOK_PVT dependencies on AR_LOCKBOXES

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 57: /* * Bug 7504497 Line Level Cash Application Rule is fetched from ar_lockboxes *

53: and a.lockbox_id = b.requested_lockbox_id;
54: EXCEPTION
55: WHEN NO_DATA_FOUND THEN
56: arp_util.debug('Lockbox Number is given through the data file');
57: /* * Bug 7504497 Line Level Cash Application Rule is fetched from ar_lockboxes *
58: * using Lockbox_number provided in the data file. However the data in the *
59: * interface table will not be trimmed at this point which might fail in *
60: * fetching data from ar_lockboxes. Hence trimmed Lockbox number here. The *
61: * data in interface table will be trimmed later in arlvtr.lpc. * */

Line 60: * fetching data from ar_lockboxes. Hence trimmed Lockbox number here. The *

56: arp_util.debug('Lockbox Number is given through the data file');
57: /* * Bug 7504497 Line Level Cash Application Rule is fetched from ar_lockboxes *
58: * using Lockbox_number provided in the data file. However the data in the *
59: * interface table will not be trimmed at this point which might fail in *
60: * fetching data from ar_lockboxes. Hence trimmed Lockbox number here. The *
61: * data in interface table will be trimmed later in arlvtr.lpc. * */
62: BEGIN
63: UPDATE ar_payments_interface pi
64: SET pi.lockbox_number =

Line 85: from ar_lockboxes a

81: Lockbox Number is fetched only from LB Hdr/LB Trl records. */
82:
83: select distinct( nvl(a.line_level_cash_app_rule, 'N'))
84: into l_line_level_cash_app_rule
85: from ar_lockboxes a
86: where a.lockbox_number in ( select distinct(lockbox_number)
87: from ar_payments_interface
88: where transmission_request_id = in_trans_req_id
89: and lockbox_number is not null );