DBA Data[Home] [Help]

APPS.IGS_EN_GEN_005 dependencies on IGS_EN_GEN_014

Line 633: SELECT SUBSTR(IGS_EN_GEN_014.enrs_get_acad_alt_cd(sua_v.cal_type,sua_v.ci_sequence_number),1,10)

629: BEGIN
630: DECLARE
631: -- modified cursor for performance bug 3687265
632: CURSOR c_get_acad_alt_cd IS
633: SELECT SUBSTR(IGS_EN_GEN_014.enrs_get_acad_alt_cd(sua_v.cal_type,sua_v.ci_sequence_number),1,10)
634: FROM IGS_EN_SU_ATTEMPT sua_v,
635: IGS_CA_INST ci
636: WHERE sua_v.person_id = p_person_id AND
637: sua_v.enrolled_dt IS NOT NULL AND

Line 681: SELECT SUBSTR(IGS_EN_GEN_014.enrs_get_acad_alt_cd(sua_v.cal_type,sua_v.ci_sequence_number),1,10)

677: BEGIN
678: DECLARE
679: --modified cursor for performance bug 3687150
680: CURSOR c_get_acad_alt_cd IS
681: SELECT SUBSTR(IGS_EN_GEN_014.enrs_get_acad_alt_cd(sua_v.cal_type,sua_v.ci_sequence_number),1,10)
682: FROM IGS_EN_SU_ATTEMPT sua_v,
683: IGS_CA_INST ci
684: WHERE sua_v.person_id = p_person_id AND
685: sua_v.enrolled_dt IS NOT NULL AND