DBA Data[Home] [Help]

APPS.IGS_SS_ENROLL_PKG dependencies on IGS_PS_STDNT_TRN

Line 810: -- submitted once. This is being determined by the presence of the program attempt transfer record in the table IGS_PS_STDNT_TRN

806: --Created by : sarakshi, Oracle IDC
807: --Date created: 09-NOV-2004
808: --
809: --Purpose:The following function is used to determine if the destination program attempt has been selected and program transfer
810: -- submitted once. This is being determined by the presence of the program attempt transfer record in the table IGS_PS_STDNT_TRN
811: --Known limitations/enhancements and/or remarks:
812: --
813: --Change History:
814: --Who When What

Line 819: FROM igs_ps_stdnt_trn

815: --
816: -------------------------------------------------------------------
817: CURSOR cur_prg_trns IS
818: SELECT 'X'
819: FROM igs_ps_stdnt_trn
820: WHERE course_cd= p_dest_program_cd
821: AND transfer_course_cd = p_source_program_cd
822: AND person_id = p_person_id;
823: l_c_var VARCHAR2(1);