APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_PE_CITIZENSHIP_V

Line 2307: CURSOR cur_citizen_exist (cp_person_id IGS_PE_CITIZENSHIP_V.party_id%TYPE,

2303: WHERE association_code = cp_assoc
2304: AND map1 = cp_map1;
2305: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
2306:
2307: CURSOR cur_citizen_exist (cp_person_id IGS_PE_CITIZENSHIP_V.party_id%TYPE,
2308: cp_country_code IGS_PE_CITIZENSHIP_V.country_code%TYPE) IS
2309: SELECT 'X'
2310: FROM IGS_PE_CITIZENSHIP_V
2311: WHERE party_id = cp_person_id

Line 2308: cp_country_code IGS_PE_CITIZENSHIP_V.country_code%TYPE) IS

2304: AND map1 = cp_map1;
2305: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
2306:
2307: CURSOR cur_citizen_exist (cp_person_id IGS_PE_CITIZENSHIP_V.party_id%TYPE,
2308: cp_country_code IGS_PE_CITIZENSHIP_V.country_code%TYPE) IS
2309: SELECT 'X'
2310: FROM IGS_PE_CITIZENSHIP_V
2311: WHERE party_id = cp_person_id
2312: AND country_code = cp_country_code;

Line 2310: FROM IGS_PE_CITIZENSHIP_V

2306:
2307: CURSOR cur_citizen_exist (cp_person_id IGS_PE_CITIZENSHIP_V.party_id%TYPE,
2308: cp_country_code IGS_PE_CITIZENSHIP_V.country_code%TYPE) IS
2309: SELECT 'X'
2310: FROM IGS_PE_CITIZENSHIP_V
2311: WHERE party_id = cp_person_id
2312: AND country_code = cp_country_code;
2313: l_dummy VARCHAR2(1);
2314: