APPS.IGF_AW_MANAGE_AWD dependencies on IGS_PE_PERSON_BASE_V

Line 479: person_number igs_pe_person_base_v.person_number%TYPE

475: cur_per_grp CpregrpCurTyp ;
476:
477: TYPE CpergrpTyp IS RECORD(
478: person_id igf_ap_fa_base_rec_all.person_id%TYPE,
479: person_number igs_pe_person_base_v.person_number%TYPE
480: );
481: per_grp_rec CpergrpTyp ;
482:
483:

Line 756: FROM igs_pe_person_base_v

752: IF lv_group_type = 'STATIC' THEN
753: OPEN cur_per_grp FOR
754: 'SELECT person_id,
755: person_number
756: FROM igs_pe_person_base_v
757: WHERE person_id IN ('||lv_sql_stmt||') ' USING p_pid_group;
758: ELSIF lv_group_type = 'DYNAMIC' THEN
759: OPEN cur_per_grp FOR
760: 'SELECT person_id,

Line 762: FROM igs_pe_person_base_v

758: ELSIF lv_group_type = 'DYNAMIC' THEN
759: OPEN cur_per_grp FOR
760: 'SELECT person_id,
761: person_number
762: FROM igs_pe_person_base_v
763: WHERE person_id IN ('||lv_sql_stmt||')';
764: END IF;
765:
766: FETCH cur_per_grp INTO per_grp_rec;