APPS.ARP_LOCKBOX_HOOK_PVT dependencies on AR_TRANS_FIELD_FORMATS

Line 69: ar_trans_field_formats ff,

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

Line 478: FROM ar_trans_field_formats

474: /* Check if the format includes batches */
475: BEGIN
476: SELECT distinct 'Y'
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

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: