APPS.ARP_LOCKBOX_HOOK_PVT dependencies on AR_TRANS_FIELD_FORMATS

Line 72: ar_trans_field_formats ff,

68: (SELECT decode(ff.justification_lookup_code,
69: 'LEFT', RTRIM(pi.lockbox_number, decode(ff.fill_character_lookup_code, 'ZERO', '0', 'BLANK', ' ')),
70: 'RIGHT', LTRIM(pi.lockbox_number,decode(ff.fill_character_lookup_code, 'ZERO', '0', 'BLANK', ' ')))
71: FROM ar_transmissions tr,
72: ar_trans_field_formats ff,
73: ar_trans_record_formats rf
74: WHERE tr.transmission_id = pi.transmission_id
75: AND ff.transmission_format_id = tr.requested_trans_format_id
76: AND rf.record_format_id = ff.record_format_id

Line 493: FROM ar_trans_field_formats

489: /* Check if the format includes batches */
490: BEGIN
491: SELECT distinct 'Y'
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

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: