APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_STAT_DETAILS

Line 1538: FROM igs_pe_stat_details psd

1534: AND ev_form_id = p_person_rec.form_id;
1535:
1536: CURSOR c_country_reason(cp_person_id number) IS
1537: SELECT psd.birth_cntry_resn_code
1538: FROM igs_pe_stat_details psd
1539: WHERE psd.person_id = cp_person_id;
1540:
1541:
1542: l_last_name hz_person_profiles.person_last_name%TYPE;

Line 1557: l_birth_cntry_resn_code igs_pe_stat_details.birth_cntry_resn_code%TYPE;

1553: l_legal_res_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1554: l_position_code IGS_PE_EV_FORM.position_code%TYPE;
1555: l_category_code IGS_PE_EV_FORM.category_code%TYPE;
1556: l_position_remarks IGS_PE_EV_FORM.position_remarks%TYPE;
1557: l_birth_cntry_resn_code igs_pe_stat_details.birth_cntry_resn_code%TYPE;
1558:
1559: l_not_valid BOOLEAN :=FALSE;
1560: BEGIN
1561: -- Visa type valies