APPS.IGF_AW_COA_UPDATE dependencies on IGS_PE_PERSON_BASE_V

Line 744: person_number igs_pe_person_base_v.person_number%TYPE

740: cur_per_grp CpregrpCurTyp ;
741:
742: TYPE CpergrpTyp IS RECORD(
743: person_id igf_ap_fa_base_rec_all.person_id%TYPE,
744: person_number igs_pe_person_base_v.person_number%TYPE
745: );
746: per_grp_rec CpergrpTyp ;
747:
748:

Line 977: FROM igs_pe_person_base_v

973: IF lv_group_type = 'STATIC' THEN
974: OPEN cur_per_grp FOR
975: 'SELECT person_id,
976: person_number
977: FROM igs_pe_person_base_v
978: WHERE person_id IN ('||lv_sql_stmt||') ' USING p_pid_group;
979: ELSIF lv_group_type = 'DYNAMIC' THEN
980: OPEN cur_per_grp FOR
981: 'SELECT person_id,

Line 983: FROM igs_pe_person_base_v

979: ELSIF lv_group_type = 'DYNAMIC' THEN
980: OPEN cur_per_grp FOR
981: 'SELECT person_id,
982: person_number
983: FROM igs_pe_person_base_v
984: WHERE person_id IN ('||lv_sql_stmt||')';
985: END IF;
986:
987: FETCH cur_per_grp INTO per_grp_rec;