APPS.IGS_FI_LOAD_EXT_CHG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 886: FUNCTION get_std_formerstd_ind(p_person_id IN igs_pe_typ_instances_all.person_id%TYPE )

882: igs_ge_msg_stack.add;
883: igs_ge_msg_stack.conc_exception_hndl;
884: END igs_fi_extto_imp;
885:
886: FUNCTION get_std_formerstd_ind(p_person_id IN igs_pe_typ_instances_all.person_id%TYPE )
887: RETURN VARCHAR2 AS
888: /******************************************************************
889: Created By :Prasad marada
890: Date Created By :30-Nov-2004

Line 904: CURSOR c_person_typ (cp_person_id igs_pe_typ_instances_all.person_id%TYPE) IS

900: ********************************************************************/
901: l_n_count NUMBER;
902: l_v_output VARCHAR2(1);
903:
904: CURSOR c_person_typ (cp_person_id igs_pe_typ_instances_all.person_id%TYPE) IS
905: SELECT 1
906: FROM igs_pe_typ_instances_all pti, igs_pe_person_types pty
907: WHERE pti.person_type_code = pty.person_type_code AND
908: pty.system_type IN ('STUDENT','FORMER_STUDENT') AND

Line 906: FROM igs_pe_typ_instances_all pti, igs_pe_person_types pty

902: l_v_output VARCHAR2(1);
903:
904: CURSOR c_person_typ (cp_person_id igs_pe_typ_instances_all.person_id%TYPE) IS
905: SELECT 1
906: FROM igs_pe_typ_instances_all pti, igs_pe_person_types pty
907: WHERE pti.person_type_code = pty.person_type_code AND
908: pty.system_type IN ('STUDENT','FORMER_STUDENT') AND
909: pti.person_id = cp_person_id;
910: