DBA Data[Home] [Help]

APPS.OKL_LCKBX_CSH_APP_PVT dependencies on AR_TRANSMISSIONS_ALL

Line 92: FROM ar_transmissions_all trans,

88: cp_record_type IN VARCHAR2,
89: cp_column_type IN VARCHAR2
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

Line 654: FROM ar_transmissions_all a, ar_trans_record_formats b

650: CURSOR c_get_trans_fmt (cp_trans_req_id IN NUMBER) IS
651: SELECT b.record_identifier,
652: b.record_type_lookup_code,
653: b.transmission_format_id
654: FROM ar_transmissions_all a, ar_trans_record_formats b
655: WHERE a.requested_trans_format_id = b.transmission_format_id
656: AND a.transmission_request_id = cp_trans_req_id
657: ORDER BY b.record_identifier;
658: