APPS.IGS_PE_CITIZENSHIPS_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 21: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;

17: --Change History:
18: --Who When What
19: ----------------------------------------------------------------------------------------------
20:
21: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;
22: l_default_date DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
23:
24: CURSOR validate_brth_dt(cp_person_id NUMBER) IS
25: SELECT birth_date

Line 26: FROM IGS_PE_PERSON_BASE_V

22: l_default_date DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
23:
24: CURSOR validate_brth_dt(cp_person_id NUMBER) IS
25: SELECT birth_date
26: FROM IGS_PE_PERSON_BASE_V
27: WHERE person_id = cp_person_id ;
28:
29: CURSOR validate_dt_overlap(cp_party_id NUMBER, cp_start_date DATE, cp_end_date DATE , cp_citzn_id NUMBER , cp_country_cd VARCHAR2) IS
30: SELECT 'X'