APPS.IGF_AP_VER_GRPS_PRC_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 80: FROM igs_pe_person_base_v pe,

76:
77: -- Get the person_number
78: CURSOR c_person_number( cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ) IS
79: SELECT pe.person_number
80: FROM igs_pe_person_base_v pe,
81: igf_ap_fa_base_rec_all fa
82: WHERE pe.person_id = fa.person_id
83: AND fa.base_id = cp_base_id;
84:

Line 112: l_person_number igs_pe_person_base_v.person_number%TYPE;

108: lv_item_code_pmpt igf_lookups_view.meaning%TYPE ;
109: lv_isir_field_pmpt igf_lookups_view.meaning%TYPE ;
110: l_para_pass igf_lookups_view.meaning%TYPE ;
111:
112: l_person_number igs_pe_person_base_v.person_number%TYPE;
113: l_group_desc igs_pe_persid_group_all.description%TYPE;
114: l_item_description igf_ap_td_item_mst_all.description%TYPE;
115:
116:

Line 575: TYPE c_person_id_grp_recTyp IS RECORD ( person_id igs_pe_person_base_v.person_id%TYPE, person_number igs_pe_person_base_v.person_number%TYPE,

571: lv_sql_cnt VARCHAR(32767) ;
572:
573: TYPE c_person_id_grpCurTyp IS REF CURSOR ;
574: c_person_id_grp c_person_id_grpCurTyp ;
575: TYPE c_person_id_grp_recTyp IS RECORD ( person_id igs_pe_person_base_v.person_id%TYPE, person_number igs_pe_person_base_v.person_number%TYPE,
576: full_name igs_pe_person_base_v.full_name%TYPE );
577: c_person_id_grp_rec c_person_id_grp_recTyp ;
578:
579: -- Check whether the sudent exists in the FA system or not.

Line 576: full_name igs_pe_person_base_v.full_name%TYPE );

572:
573: TYPE c_person_id_grpCurTyp IS REF CURSOR ;
574: c_person_id_grp c_person_id_grpCurTyp ;
575: TYPE c_person_id_grp_recTyp IS RECORD ( person_id igs_pe_person_base_v.person_id%TYPE, person_number igs_pe_person_base_v.person_number%TYPE,
576: full_name igs_pe_person_base_v.full_name%TYPE );
577: c_person_id_grp_rec c_person_id_grp_recTyp ;
578:
579: -- Check whether the sudent exists in the FA system or not.
580: CURSOR c_fa_base( cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE ,

Line 594: FROM igf_ap_fa_base_rec fa, igs_pe_person_base_v pe

590:
591: -- Get the person number and person name with the person id.
592: CURSOR c_person_details( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
593: SELECT pe.person_number, pe.full_name, fa.person_id
594: FROM igf_ap_fa_base_rec fa, igs_pe_person_base_v pe
595: WHERE fa.base_id = cp_base_id
596: AND fa.person_id = pe.person_id;
597:
598:

Line 731: FROM igs_pe_person_base_v

727: --Bug #5021084. Passing Group ID if the group type is STATIC.
728: IF lv_group_type = 'STATIC' THEN
729: -- Get all the Active students from the Person Group
730: OPEN c_person_id_grp FOR 'SELECT person_id,person_number,full_name
731: FROM igs_pe_person_base_v
732: WHERE person_id in ('||lv_sql_stmt||') ' USING p_prs_grp_id;
733: ELSIF lv_group_type = 'DYNAMIC' THEN
734: -- Get all the Active students from the Person Group
735: OPEN c_person_id_grp FOR 'SELECT person_id,person_number,full_name

Line 736: FROM igs_pe_person_base_v

732: WHERE person_id in ('||lv_sql_stmt||') ' USING p_prs_grp_id;
733: ELSIF lv_group_type = 'DYNAMIC' THEN
734: -- Get all the Active students from the Person Group
735: OPEN c_person_id_grp FOR 'SELECT person_id,person_number,full_name
736: FROM igs_pe_person_base_v
737: WHERE person_id in ('||lv_sql_stmt||')';
738: END IF;
739:
740: LOOP