APPS.IGS_PR_GEN_004 dependencies on IGS_PS_GRP_MBR

Line 541: FROM IGS_PS_GRP_MBR cgm

537: ) OR
538: (cp_spo_encmb_course_group_cd IS NOT NULL AND
539: EXISTS (
540: SELECT 'X'
541: FROM IGS_PS_GRP_MBR cgm
542: WHERE cgm.course_group_cd = cp_spo_encmb_course_group_cd AND
543: cgm.course_cd = cp_course_cd AND
544: cgm.version_number = cp_sca_version_number))) AND
545: spo.person_id = cp_person_id AND

Line 564: FROM IGS_PS_GRP_MBR cgm

560: ) OR
561: (spo.encmb_course_group_cd IS NOT NULL AND
562: EXISTS (
563: SELECT 'X'
564: FROM IGS_PS_GRP_MBR cgm
565: WHERE cgm.course_group_cd = spo.encmb_course_group_cd AND
566: cgm.course_cd = cp_course_cd AND
567: cgm.version_number = cp_sca_version_number)));
568: CURSOR c_sca1 (

Line 605: FROM IGS_PS_GRP_MBR cgm

601: spc.course_cd = sca.course_cd) OR
602: (cp_spo_encmb_course_group_cd IS NOT NULL AND
603: EXISTS (
604: SELECT 'X'
605: FROM IGS_PS_GRP_MBR cgm
606: WHERE cgm.course_group_cd = cp_spo_encmb_course_group_cd AND
607: cgm.course_cd = sca.course_cd AND
608: cgm.version_number = sca.version_number)
609: ));

Line 6398: FROM IGS_PS_GRP_MBR cgm

6394: spc.course_cd = sca.course_cd) OR
6395: (spo.encmb_course_group_cd IS NOT NULL AND
6396: EXISTS (
6397: SELECT 'X'
6398: FROM IGS_PS_GRP_MBR cgm
6399: WHERE cgm.course_group_cd = spo.encmb_course_group_cd AND
6400: cgm.course_cd = sca.course_cd AND
6401: cgm.version_number = sca.version_number))))));
6402: CURSOR c_sca2 IS

Line 6473: FROM IGS_PS_GRP_MBR cgm

6469: spc.course_cd = sca.course_cd) OR
6470: (spo.encmb_course_group_cd IS NOT NULL AND
6471: EXISTS (
6472: SELECT 'X'
6473: FROM IGS_PS_GRP_MBR cgm
6474: WHERE cgm.course_group_cd = spo.encmb_course_group_cd AND
6475: cgm.course_cd = sca.course_cd AND
6476: cgm.version_number = sca.version_number)))));
6477: