APPS.IGS_OR_INST_IMP_001 dependencies on IGS_OR_CWLK_V

Line 353: FROM IGS_OR_CWLK_V ORCV

349: p_inst_rec c_inst_cur%ROWTYPE;
350:
351: CURSOR c_inst_code ( cp_data_source VARCHAR2 , cp_data_src_val VARCHAR2 ) IS
352: SELECT orcv.crosswalk_id, orcv.crosswalk_dtl_id, orcv.inst_code
353: FROM IGS_OR_CWLK_V ORCV
354: WHERE ORCV.ALT_ID_TYPE = cp_data_source AND
355: ORCV.ALT_ID_VALUE = cp_data_src_val ;
356:
357: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties

Line 1031: FROM IGS_OR_CWLK_V ORCV

1027: IO.BATCH_ID = cp_batch_id ;
1028:
1029: CURSOR c_inst_code ( p_data_source VARCHAR2 , p_data_src_val VARCHAR2 ) IS
1030: SELECT crosswalk_id, crosswalk_dtl_id, inst_code
1031: FROM IGS_OR_CWLK_V ORCV
1032: WHERE ORCV.ALT_ID_TYPE = p_data_source AND
1033: ORCV.ALT_ID_VALUE = p_data_src_val ;
1034:
1035: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties

Line 1539: FROM IGS_OR_CWLK_V ORCV

1535: -- removed the to_number function from cp_data_src_val and put the like instead of =
1536: -- and added one more column ALT_ID_VALUE in the select query
1537: CURSOR c_inst_code ( cp_data_source VARCHAR2 , cp_data_src_val VARCHAR2 ) IS
1538: SELECT crosswalk_id, crosswalk_dtl_id,inst_code, ALT_ID_VALUE
1539: FROM IGS_OR_CWLK_V ORCV
1540: WHERE ORCV.ALT_ID_TYPE = cp_data_source AND
1541: ORCV.ALT_ID_VALUE like '%' || cp_data_src_val;
1542:
1543: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties

Line 2618: p_cwlk_inst_code IN igs_or_cwlk_v.inst_code%TYPE,

2614:
2615: FUNCTION validate_inst_code(
2616: p_new_inst_code IN igs_or_inst_int.new_institution_cd%TYPE,
2617: p_exst_inst_code IN igs_or_inst_int.exst_institution_cd%TYPE,
2618: p_cwlk_inst_code IN igs_or_cwlk_v.inst_code%TYPE,
2619: p_interface_id IN igs_or_inst_int.interface_id%TYPE)
2620: RETURN BOOLEAN AS
2621: /*
2622: || Created By : ssaleem