APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_PE_PERSID_GROUP

Line 528: FUNCTION validate_person_grp(p_n_person_id_grp igs_pe_persid_group.group_id%TYPE) RETURN BOOLEAN AS

524:
525: RETURN l_b_return_val;
526: END validate_person;
527:
528: FUNCTION validate_person_grp(p_n_person_id_grp igs_pe_persid_group.group_id%TYPE) RETURN BOOLEAN AS
529: /******************************************************************
530: Created By : Vinay Chappidi
531: Date Created By : 05-DEC-2002
532: Purpose : validates Person Id Group

Line 545: FROM igs_pe_persid_group

541:
542: CURSOR c_check_prsn_grp
543: IS
544: SELECT group_cd
545: FROM igs_pe_persid_group
546: WHERE group_id= p_n_person_id_grp AND
547: TRUNC(create_dt)<= TRUNC(SYSDATE) AND
548: closed_ind = 'N';
549: l_c_group_cd igs_pe_persid_group.group_cd%TYPE;

Line 549: l_c_group_cd igs_pe_persid_group.group_cd%TYPE;

545: FROM igs_pe_persid_group
546: WHERE group_id= p_n_person_id_grp AND
547: TRUNC(create_dt)<= TRUNC(SYSDATE) AND
548: closed_ind = 'N';
549: l_c_group_cd igs_pe_persid_group.group_cd%TYPE;
550:
551: l_b_return_val BOOLEAN;
552: l_v_message_text fnd_new_messages.message_text%TYPE;
553: