APPS.IGS_GE_GEN_001 dependencies on IGS_PE_PERSON_BASE_V

Line 1121: -- change the reference from igs_pe_person_v to igs_pe_person_base_v --rghosh

1117: RETURN VARCHAR2 AS
1118:
1119: l_name VARCHAR2(450);
1120: CURSOR name IS
1121: -- change the reference from igs_pe_person_v to igs_pe_person_base_v --rghosh
1122: SELECT full_name FROM igs_pe_person_base_v
1123: WHERE person_id = x_person_id;
1124: BEGIN
1125: IF x_person_id IS NULL THEN

Line 1122: SELECT full_name FROM igs_pe_person_base_v

1118:
1119: l_name VARCHAR2(450);
1120: CURSOR name IS
1121: -- change the reference from igs_pe_person_v to igs_pe_person_base_v --rghosh
1122: SELECT full_name FROM igs_pe_person_base_v
1123: WHERE person_id = x_person_id;
1124: BEGIN
1125: IF x_person_id IS NULL THEN
1126: return NULL;