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

55: WHEN NO_DATA_FOUND THEN
56: IF PG_DEBUG in ('Y', 'C') THEN
57: arp_util.debug('Lockbox Number is given through the data file');
58: END IF;
59: /* * Bug 7504497 Line Level Cash Application Rule is fetched from ar_lockboxes *
60: * using Lockbox_number provided in the data file. However the data in the *
61: * interface table will not be trimmed at this point which might fail in *
62: * fetching data from ar_lockboxes. Hence trimmed Lockbox number here. The *
63: * data in interface table will be trimmed later in arlvtr.lpc. * */

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

58: END IF;
59: /* * Bug 7504497 Line Level Cash Application Rule is fetched from ar_lockboxes *
60: * using Lockbox_number provided in the data file. However the data in the *
61: * interface table will not be trimmed at this point which might fail in *
62: * fetching data from ar_lockboxes. Hence trimmed Lockbox number here. The *
63: * data in interface table will be trimmed later in arlvtr.lpc. * */
64: BEGIN
65: /* Bug 14746822 : This code moved to arlplb.opc
66: UPDATE ar_payments_interface pi

Line 88: from ar_lockboxes a

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