APPS.IGF_AP_TODO_GRPS_PRC_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 138: FROM igs_pe_person_base_v pe,

134: CURSOR c_person_number(
135: cp_base_id IN NUMBER
136: ) IS
137: SELECT pe.person_number
138: FROM igs_pe_person_base_v pe,
139: igf_ap_fa_base_rec_all fa
140: WHERE pe.person_id = fa.person_id
141: AND fa.base_id = cp_base_id;
142:

Line 724: 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, full_name igs_pe_person_base_v.full_name%TYPE );

720: lv_sql_stmt VARCHAR(32767) := igf_ap_ss_pkg.get_pid(p_person_id_grp,lv_status,lv_group_type);
721:
722: TYPE c_person_id_grpCurTyp IS REF CURSOR ;
723: c_person_id_grp c_person_id_grpCurTyp ;
724: 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, full_name igs_pe_person_base_v.full_name%TYPE );
725: c_person_id_grp_rec c_person_id_grp_recTyp ;
726:
727: /* CURSOR c_person_id_grp (cp_person_id_grp igs_pe_persid_group_all.group_id%TYPE) IS
728: SELECT person_id, person_number, full_name

Line 754: igs_pe_person_base_v pe

750: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
751: ) IS
752: SELECT pe.person_number, pe.full_name person_name, fa.person_id
753: FROM igf_ap_fa_base_rec fa,
754: igs_pe_person_base_v pe
755: WHERE fa.base_id = cp_base_id
756: AND fa.person_id = pe.person_id;
757:
758: --- Get the Person Number prompt

Line 1072: FROM igs_pe_person_base_v

1068: --Bug #5021084. Passing Group ID if the group type is STATIC.
1069: IF lv_group_type = 'STATIC' THEN
1070: -- Get all the Active students from the Person Group
1071: OPEN c_person_id_grp FOR 'SELECT person_id,person_number,full_name
1072: FROM igs_pe_person_base_v
1073: WHERE person_id in ('||lv_sql_stmt||') ' USING p_person_id_grp;
1074: ELSIF lv_group_type = 'DYNAMIC' THEN
1075: -- Get all the Active students from the Person Group
1076: OPEN c_person_id_grp FOR 'SELECT person_id,person_number,full_name

Line 1077: FROM igs_pe_person_base_v

1073: WHERE person_id in ('||lv_sql_stmt||') ' USING p_person_id_grp;
1074: ELSIF lv_group_type = 'DYNAMIC' THEN
1075: -- Get all the Active students from the Person Group
1076: OPEN c_person_id_grp FOR 'SELECT person_id,person_number,full_name
1077: FROM igs_pe_person_base_v
1078: WHERE person_id in ('||lv_sql_stmt||')';
1079: END IF;
1080:
1081: LOOP