APPS.IGF_SE_GEN_001 dependencies on IGS_PE_PERSON_BASE_V

Line 312: FROM igs_pe_person_base_v

308: WHERE party_id = cv_person_id;
309:
310: CURSOR c_pe (cv_person_id hz_parties.party_id%TYPE ) IS
311: SELECT gender sex, birth_date birth_dt
312: FROM igs_pe_person_base_v
313: WHERE person_id = cv_person_id;
314:
315: CURSOR c_visa (cv_person_id hz_parties.party_id%TYPE ) IS
316: SELECT a.visa_type,a.visa_category,a.visa_number,a.visa_expiry_date, b.visit_start_date entry_date

Line 1573: FROM igs_pe_person_base_v fa

1569: --veramach July 2004 FA 151 HR integration - process raises a business event instead of initiating workflow
1570: -------------------------------------------------------------------------------------
1571: CURSOR c_person IS
1572: SELECT fa.person_number, fa.full_name
1573: FROM igs_pe_person_base_v fa
1574: WHERE fa.person_id = p_person_id ;
1575:
1576: CURSOR c_fund IS
1577: SELECT fund_code,threshold_perct,threshold_value