DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_AV_STND_UNIT

Line 1666: FROM igs_av_stnd_unit adv, igs_ps_unit_ver psv

1662: TO_NUMBER(NULL) ci_sequence_number,
1663: TO_NUMBER(NULL) uoo_id,
1664: adv.achievable_credit_points override_enrolled_cp ,
1665: adv.as_course_cd course_cd
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' )

Line 2051: FROM igs_av_stnd_unit adv

2047: TO_NUMBER(NULL) ci_sequence_number,
2048: TO_NUMBER(NULL) uoo_id,
2049: adv.achievable_credit_points override_enrolled_cp ,
2050: adv.as_course_cd course_cd
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' )