APPS.IGS_GR_VAL_GR dependencies on IGS_PE_PERSON_BASE_V

Line 796: cp_id IGS_PE_PERSON_BASE_V.person_id%TYPE) IS

792: DECLARE
793: cst_attending CONSTANT IGS_GR_GRADUAND.s_graduand_type%TYPE := 'ATTENDING';
794: v_pe_exists VARCHAR2(1);
795: CURSOR c_pe(
796: cp_id IGS_PE_PERSON_BASE_V.person_id%TYPE) IS
797: SELECT 'x'
798: FROM IGS_PE_PERSON_BASE_V pe
799: WHERE pe.person_id = cp_id AND
800: pe.date_of_death is not NULL;

Line 798: FROM IGS_PE_PERSON_BASE_V pe

794: v_pe_exists VARCHAR2(1);
795: CURSOR c_pe(
796: cp_id IGS_PE_PERSON_BASE_V.person_id%TYPE) IS
797: SELECT 'x'
798: FROM IGS_PE_PERSON_BASE_V pe
799: WHERE pe.person_id = cp_id AND
800: pe.date_of_death is not NULL;
801: BEGIN
802: -- Set the default message number