[Home] [Help]
499: WHERE lk.lookup_type = 'OR_INST_EXEMPTIONS'
500: AND lk.enabled_flag = 'Y'
501: AND lk.lookup_code = cp_exemption_institution_cd;
502: CURSOR c_institution (
503: cp_exemption_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE) IS
504: SELECT 'x'
505: FROM hz_parties hp,
506: igs_pe_hz_parties ihp
507: WHERE ihp.oss_org_unit_cd = cp_exemption_institution_cd --swaghmar bug# 4377816