DBA Data[Home] [Help]

APPS.AR_SUBMIT_LOCKBOX dependencies on AR_TRANS_FIELD_FORMATS

Line 281: FROM ar_trans_field_formats fld,

277:
278: BEGIN
279: SELECT 'Y'
280: INTO l_lb_num_exists
281: FROM ar_trans_field_formats fld,
282: ar_trans_record_formats rec
283: WHERE rec.transmission_format_id = l_trans_format_id
284: AND rec.record_type_lookup_code in ('LB HDR', 'LB TRL')
285: AND rec.record_format_id = fld.record_format_id

Line 339: ar_trans_field_formats tff

335: BEGIN
336: SELECT 'Y'
337: INTO l_dep_date_exists
338: FROM ar_trans_record_formats trf,
339: ar_trans_field_formats tff
340: WHERE trf.transmission_format_id = l_trans_format_id
341: AND trf.record_format_id = tff.record_format_id
342: AND tff.field_type_lookup_code = 'DEPOSIT DATE'
343: AND ROWNUM < 2;