APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_AV_VAL_ASU

Line 1670: AND igs_av_val_asu.granted_adv_standing(adv.person_id,adv.as_course_cd,adv.as_version_number,adv.unit_cd,adv.version_number,'GRANTED',NULL) ='TRUE' )

1666: FROM igs_av_stnd_unit adv, igs_ps_unit_ver psv
1667: WHERE adv.person_id = p_person_id
1668: AND adv.s_adv_stnd_granting_status = 'GRANTED'
1669: AND (adv.s_adv_stnd_recognition_type = 'CREDIT'
1670: AND igs_av_val_asu.granted_adv_standing(adv.person_id,adv.as_course_cd,adv.as_version_number,adv.unit_cd,adv.version_number,'GRANTED',NULL) ='TRUE' )
1671: AND cp_include_in_adv_stand = 'Y'
1672: AND adv.unit_cd = psv.unit_cd
1673: AND adv.version_number = psv.version_number
1674: AND ( ( adv.unit_cd = cp_unit_cd AND adv.version_number = cp_version_number )

Line 2055: AND igs_av_val_asu.granted_adv_standing(adv.person_id,adv.as_course_cd,adv.as_version_number,adv.unit_cd,adv.version_number,'GRANTED',NULL) ='TRUE' )

2051: FROM igs_av_stnd_unit adv
2052: WHERE adv.person_id = p_person_id
2053: AND adv.s_adv_stnd_granting_status = 'GRANTED'
2054: AND (adv.s_adv_stnd_recognition_type = 'CREDIT'
2055: AND igs_av_val_asu.granted_adv_standing(adv.person_id,adv.as_course_cd,adv.as_version_number,adv.unit_cd,adv.version_number,'GRANTED',NULL) ='TRUE' )
2056: AND adv.unit_cd = cp_unit_cd
2057: AND adv.version_number = cp_version_number;
2058:
2059: --