APPS.IGS_SV_NI_BATCH_PROCESS_PKG dependencies on IGS_PE_STAT_DETAILS

Line 1316: FROM igs_pe_stat_details psd

1312: AND ev_form_id = p_person_rec.form_id;
1313:
1314: CURSOR c_country_reason(cp_person_id number) IS
1315: SELECT psd.birth_cntry_resn_code
1316: FROM igs_pe_stat_details psd
1317: WHERE psd.person_id = cp_person_id;
1318:
1319:
1320: l_last_name hz_person_profiles.person_last_name%TYPE;

Line 1335: l_birth_cntry_resn_code igs_pe_stat_details.birth_cntry_resn_code%TYPE;

1331: l_legal_res_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1332: l_position_code IGS_PE_EV_FORM.position_code%TYPE;
1333: l_category_code IGS_PE_EV_FORM.category_code%TYPE;
1334: l_position_remarks IGS_PE_EV_FORM.position_remarks%TYPE;
1335: l_birth_cntry_resn_code igs_pe_stat_details.birth_cntry_resn_code%TYPE;
1336:
1337: l_not_valid BOOLEAN :=FALSE;
1338: BEGIN
1339: -- Visa type valies