APPS.IGS_AD_IMP_024 dependencies on IGS_AD_CODE_CLASSES_V

Line 400: AND EXISTS ( SELECT 1 FROM igs_ad_code_classes_v code

396: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)
397: WHERE interface_run_id = p_interface_run_id
398: AND status = '2'
399: AND trans.transcript_source IS NOT NULL
400: AND EXISTS ( SELECT 1 FROM igs_ad_code_classes_v code
401: WHERE code.system_status = 'THIRD_PARTY_TRANSFER_EVAL'
402: AND code.class_type_code = 'ADM_CODE_CLASSES'
403: AND code.class = 'TRANSCRIPT_SOURCE'
404: AND code.code_id = trans.transcript_source);

Line 953: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code

949: ,error_code = 'E334'
950: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)
951: WHERE interface_run_id = p_interface_run_id
952: AND status = '2'
953: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code
954: WHERE trans.interface_transcript_id = term.interface_transcript_id
955: AND trans.transcript_source = code.code_id
956: AND code.class = 'TRANSCRIPT_SOURCE'
957: AND code.system_status = 'THIRD_PARTY_TRANSFER_EVAL'

Line 1389: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code,

1385: , error_code = 'E334'
1386: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)
1387: WHERE interface_run_id = p_interface_run_id
1388: AND status = '2'
1389: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code,
1390: igs_ad_trmdt_int term
1391: WHERE trans.interface_transcript_id = term.interface_transcript_id
1392: AND term.interface_term_dtls_id = unit.interface_term_dtls_id
1393: AND trans.transcript_source = code.code_id