APPS.OKL_LCKBX_CSH_APP_PVT dependencies on AR_TRANS_FIELD_FORMATS

Line 94: ar_trans_field_formats fld

90: ) IS
91: SELECT NVL (fld.amount_format_lookup_code, 'N')
92: FROM ar_transmissions_all trans,
93: ar_trans_record_formats rec,
94: ar_trans_field_formats fld
95: WHERE trans.transmission_request_id = cp_trans_req_id
96: AND trans.requested_trans_format_id = rec.transmission_format_id
97: AND rec.record_type_lookup_code = cp_record_type
98: AND rec.record_format_id = fld.record_format_id

Line 363: l_overflow_rec_indicator ar_trans_field_formats.overflow_rec_indicator%TYPE

359: l_record_identifier ar_trans_record_formats.record_identifier%TYPE
360: DEFAULT NULL;
361: l_record_type_lookup_code ar_trans_record_formats.record_type_lookup_code%TYPE
362: DEFAULT NULL;
363: l_overflow_rec_indicator ar_trans_field_formats.overflow_rec_indicator%TYPE
364: DEFAULT NULL;
365: l_transmission_hdr ar_trans_record_formats.record_identifier%TYPE
366: DEFAULT NULL;
367: l_transmission_trl ar_trans_record_formats.record_identifier%TYPE

Line 663: FROM ar_trans_field_formats

659: ----------
660: -- get overflow indicator
661: CURSOR c_get_ovr_flw_indicator (cp_trans_frmt_id IN NUMBER) IS
662: SELECT overflow_rec_indicator
663: FROM ar_trans_field_formats
664: WHERE transmission_format_id = cp_trans_frmt_id
665: AND overflow_rec_indicator IS NOT NULL;
666:
667: ----------