APPS.IGS_FI_PRC_IMPCLC_ANC_CHGS dependencies on IGS_PE_PERSON_BASE_V

Line 1202: FROM igs_pe_person_base_v ppv,

1198: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE,
1199: cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,
1200: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE) IS
1201: SELECT 'x'
1202: FROM igs_pe_person_base_v ppv,
1203: igs_pe_alt_pers_id api
1204: WHERE ppv.person_id = api.pe_person_id
1205: AND ppv.person_id = cp_person_id
1206: AND api.person_id_type = cp_person_id_type

Line 1254: FROM igs_pe_person_base_v

1250:
1251: -- Cursor for geeting the Person Number from the Person Id
1252: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE) IS
1253: SELECT person_number
1254: FROM igs_pe_person_base_v
1255: WHERE person_id = cp_person_id;
1256: BEGIN
1257:
1258: -- Fetch the Person Number based on the Person Id passed