eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_NONIMG_FORM

Line 77: person_id igs_pe_nonimg_form.person_id%TYPE,

73: g_running_batches g_running_batches_tbl;
74:
75: TYPE c_stdnt_list IS RECORD
76: (
77: person_id igs_pe_nonimg_form.person_id%TYPE,
78: form_id igs_pe_ev_form.ev_form_id%TYPE ,
79: person_number hz_parties.party_number%TYPE,
80: no_show_flag igs_pe_ev_form.no_show_flag%TYPE ,
81: reprint_reason igs_pe_ev_form.reprint_reason%TYPE

Line 1180: FROM igs_pe_nonimg_form

1176: transfer_from_school,
1177: prgm_start_date,
1178: last_session_flag,
1179: adjudicated_flag
1180: FROM igs_pe_nonimg_form
1181: WHERE nonimg_form_id = p_person_rec.form_id ;
1182:
1183: CURSOR c_ev_data IS
1184: SELECT create_reason ,

Line 1195: l_prog_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;

1191: WHERE ev_form_id = p_person_rec.form_id ;
1192:
1193:
1194: l_not_valid boolean := FALSE;
1195: l_prog_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
1196:
1197: BEGIN
1198:
1199: /* Debug */

Line 1520: FROM igs_pe_nonimg_form

1516: AND SYSDATE BETWEEN peva.visa_issue_date AND peva.visa_expiry_date;
1517:
1518: CURSOR c_com_data IS
1519: SELECT decode(commuter_ind,'Y','1','0') commuter
1520: FROM igs_pe_nonimg_form
1521: WHERE nonimg_form_id = p_person_rec.form_id;
1522:
1523: CURSOR c_perm_res_data IS
1524: SELECT perm_res_cntry

Line 2862: FROM igs_pe_nonimg_form penf

2858: decode(penf.english_reqd,'Y','1','0') english_reqd,
2859: decode(penf.english_reqd_met,'Y','1','0') english_reqd_met,
2860: penf.not_reqd_reason,
2861: penf.educ_lvl_remarks
2862: FROM igs_pe_nonimg_form penf
2863: WHERE penf.person_id = p_person_rec.person_id
2864: AND penf.nonimg_form_id = p_person_rec.form_id;
2865:
2866: CURSOR c_ev_data IS

Line 2878: l_education_level igs_pe_nonimg_form.education_level%TYPE;

2874: AND peev.ev_form_id = p_person_rec.form_id;
2875:
2876:
2877: l_not_valid BOOLEAN := FALSE;
2878: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2879: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2880: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2881: l_minor igs_pe_nonimg_form.minor%TYPE;
2882: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

Line 2879: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;

2875:
2876:
2877: l_not_valid BOOLEAN := FALSE;
2878: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2879: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2880: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2881: l_minor igs_pe_nonimg_form.minor%TYPE;
2882: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2883: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;

Line 2880: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;

2876:
2877: l_not_valid BOOLEAN := FALSE;
2878: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2879: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2880: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2881: l_minor igs_pe_nonimg_form.minor%TYPE;
2882: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2883: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2884: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;

Line 2881: l_minor igs_pe_nonimg_form.minor%TYPE;

2877: l_not_valid BOOLEAN := FALSE;
2878: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2879: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2880: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2881: l_minor igs_pe_nonimg_form.minor%TYPE;
2882: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2883: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2884: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2885: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

Line 2882: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

2878: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2879: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2880: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2881: l_minor igs_pe_nonimg_form.minor%TYPE;
2882: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2883: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2884: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2885: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2886: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

Line 2883: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;

2879: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2880: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2881: l_minor igs_pe_nonimg_form.minor%TYPE;
2882: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2883: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2884: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2885: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2886: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2887: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

Line 2884: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;

2880: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2881: l_minor igs_pe_nonimg_form.minor%TYPE;
2882: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2883: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2884: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2885: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2886: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2887: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2888: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

Line 2885: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

2881: l_minor igs_pe_nonimg_form.minor%TYPE;
2882: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2883: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2884: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2885: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2886: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2887: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2888: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2889: l_position_code igs_pe_ev_form.position_code%TYPE;

Line 2886: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

2882: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2883: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2884: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2885: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2886: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2887: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2888: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2889: l_position_code igs_pe_ev_form.position_code%TYPE;
2890: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

Line 2887: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

2883: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2884: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2885: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2886: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2887: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2888: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2889: l_position_code igs_pe_ev_form.position_code%TYPE;
2890: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2891: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

Line 2888: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

2884: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2885: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2886: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2887: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2888: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2889: l_position_code igs_pe_ev_form.position_code%TYPE;
2890: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2891: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
2892: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;

Line 3151: FROM igs_pe_nonimg_form penf

3147: decode(penf.english_reqd,'Y','1','0') english_reqd,
3148: decode(penf.english_reqd_met,'Y','1','0') english_reqd_met,
3149: penf.not_reqd_reason,
3150: penf.educ_lvl_remarks
3151: FROM igs_pe_nonimg_form penf
3152: WHERE penf.person_id = p_data_rec.person_id
3153: AND penf.nonimg_form_id = g_nonimg_form_id;
3154:
3155: CURSOR c_ev_data IS

Line 3166: l_education_level igs_pe_nonimg_form.education_level%TYPE;

3162: WHERE peev.person_id = p_data_rec.person_id
3163: AND peev.ev_form_id = g_nonimg_form_id;
3164:
3165:
3166: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3167: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3168: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3169: l_minor igs_pe_nonimg_form.minor%TYPE;
3170: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

Line 3167: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;

3163: AND peev.ev_form_id = g_nonimg_form_id;
3164:
3165:
3166: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3167: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3168: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3169: l_minor igs_pe_nonimg_form.minor%TYPE;
3170: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3171: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;

Line 3168: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;

3164:
3165:
3166: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3167: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3168: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3169: l_minor igs_pe_nonimg_form.minor%TYPE;
3170: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3171: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
3172: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;

Line 3169: l_minor igs_pe_nonimg_form.minor%TYPE;

3165:
3166: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3167: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3168: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3169: l_minor igs_pe_nonimg_form.minor%TYPE;
3170: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3171: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
3172: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
3173: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

Line 3170: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

3166: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3167: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3168: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3169: l_minor igs_pe_nonimg_form.minor%TYPE;
3170: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3171: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
3172: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
3173: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3174: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

Line 3171: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;

3167: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3168: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3169: l_minor igs_pe_nonimg_form.minor%TYPE;
3170: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3171: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
3172: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
3173: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3174: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3175: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

Line 3172: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;

3168: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3169: l_minor igs_pe_nonimg_form.minor%TYPE;
3170: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3171: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
3172: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
3173: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3174: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3175: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3176: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

Line 3173: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

3169: l_minor igs_pe_nonimg_form.minor%TYPE;
3170: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3171: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
3172: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
3173: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3174: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3175: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3176: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3177: l_position_code igs_pe_ev_form.position_code%TYPE;

Line 3174: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

3170: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3171: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
3172: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
3173: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3174: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3175: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3176: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3177: l_position_code igs_pe_ev_form.position_code%TYPE;
3178: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

Line 3175: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

3171: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
3172: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
3173: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3174: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3175: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3176: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3177: l_position_code igs_pe_ev_form.position_code%TYPE;
3178: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3179: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

Line 3176: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

3172: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
3173: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3174: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3175: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3176: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3177: l_position_code igs_pe_ev_form.position_code%TYPE;
3178: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3179: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3180: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;

Line 3302: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

3298:
3299: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
3300: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
3301:
3302: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3303: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3304: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3305: l_position_code igs_pe_ev_form.position_code%TYPE;
3306: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

Line 3303: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

3299: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
3300: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
3301:
3302: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3303: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3304: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3305: l_position_code igs_pe_ev_form.position_code%TYPE;
3306: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3307: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

Line 3304: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

3300: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
3301:
3302: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3303: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3304: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3305: l_position_code igs_pe_ev_form.position_code%TYPE;
3306: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3307: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3308: l_education_level igs_pe_nonimg_form.education_level%TYPE;

Line 3308: l_education_level igs_pe_nonimg_form.education_level%TYPE;

3304: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3305: l_position_code igs_pe_ev_form.position_code%TYPE;
3306: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3307: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3308: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3309: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3310: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3311: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3312: l_minor igs_pe_nonimg_form.minor%TYPE;

Line 3309: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;

3305: l_position_code igs_pe_ev_form.position_code%TYPE;
3306: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3307: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3308: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3309: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3310: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3311: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3312: l_minor igs_pe_nonimg_form.minor%TYPE;
3313: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

Line 3310: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;

3306: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3307: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3308: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3309: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3310: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3311: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3312: l_minor igs_pe_nonimg_form.minor%TYPE;
3313: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3314:

Line 3311: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

3307: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3308: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3309: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3310: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3311: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3312: l_minor igs_pe_nonimg_form.minor%TYPE;
3313: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3314:
3315:

Line 3312: l_minor igs_pe_nonimg_form.minor%TYPE;

3308: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3309: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3310: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3311: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3312: l_minor igs_pe_nonimg_form.minor%TYPE;
3313: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3314:
3315:
3316:

Line 3313: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

3309: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3310: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3311: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3312: l_minor igs_pe_nonimg_form.minor%TYPE;
3313: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
3314:
3315:
3316:
3317: BEGIN

Line 3569: FROM IGS_PE_NONIMG_FORM

3565:
3566:
3567: CURSOR c_visa_type IS
3568: SELECT visa_type
3569: FROM IGS_PE_NONIMG_FORM
3570: WHERE nonimg_form_id = p_person_rec.form_id;
3571:
3572: CURSOR c_termination_reason(p_visa varchar2, p_term_reason igs_pe_nonimg_stat.termination_reason%TYPE) IS
3573: SELECT COUNT(1)

Line 3588: IGS_PE_NONIMG_FORM_V

3584: CURSOR c_prev_end_date IS
3585: SELECT
3586: PRGM_END_DATE
3587: FROM
3588: IGS_PE_NONIMG_FORM_V
3589: WHERE
3590: nonimg_form_id = p_person_rec.form_id;
3591:
3592: CURSOR c_auth_details(cp_person_id igs_sv_prgms_info.person_id%TYPE)

Line 3601: FROM igs_pe_nonimg_form

3597:
3598: CURSOR c_prgm_dates(cp_person_id igs_sv_prgms_info.person_id%TYPE)
3599: IS
3600: SELECT prgm_start_date, prgm_end_date, visa_type
3601: FROM igs_pe_nonimg_form
3602: WHERE person_id = cp_person_id
3603: AND nonimg_form_id = p_person_rec.form_id;
3604:
3605:

Line 4191: FROM igs_pe_nonimg_form penf

4187: other_funds_amt,
4188: other_funds_desc,
4189: empl_funds_amt,
4190: remarks
4191: FROM igs_pe_nonimg_form penf
4192: WHERE penf.person_id = p_person_rec.person_id
4193: AND penf.nonimg_form_id = p_person_rec.form_id;
4194:
4195: CURSOR c_ev_data IS

Line 4221: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;

4217: WHERE evf.person_id = p_person_rec.person_id
4218: AND evf.ev_form_id = p_person_rec.form_id;
4219:
4220: l_not_valid BOOLEAN := FALSE;
4221: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;
4222: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
4223: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
4224: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
4225: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;

Line 4222: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;

4218: AND evf.ev_form_id = p_person_rec.form_id;
4219:
4220: l_not_valid BOOLEAN := FALSE;
4221: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;
4222: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
4223: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
4224: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
4225: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
4226: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;

Line 4223: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;

4219:
4220: l_not_valid BOOLEAN := FALSE;
4221: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;
4222: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
4223: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
4224: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
4225: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
4226: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
4227: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;

Line 4224: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;

4220: l_not_valid BOOLEAN := FALSE;
4221: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;
4222: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
4223: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
4224: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
4225: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
4226: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
4227: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
4228: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;

Line 4225: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;

4221: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;
4222: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
4223: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
4224: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
4225: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
4226: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
4227: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
4228: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
4229: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;

Line 4226: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;

4222: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
4223: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
4224: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
4225: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
4226: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
4227: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
4228: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
4229: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
4230: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;

Line 4227: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;

4223: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
4224: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
4225: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
4226: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
4227: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
4228: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
4229: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
4230: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
4231: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;

Line 4228: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;

4224: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
4225: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
4226: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
4227: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
4228: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
4229: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
4230: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
4231: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
4232: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;

Line 4229: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;

4225: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
4226: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
4227: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
4228: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
4229: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
4230: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
4231: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
4232: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
4233: l_remarks igs_pe_nonimg_form.remarks%TYPE;

Line 4230: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;

4226: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
4227: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
4228: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
4229: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
4230: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
4231: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
4232: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
4233: l_remarks igs_pe_nonimg_form.remarks%TYPE;
4234: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;

Line 4231: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;

4227: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
4228: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
4229: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
4230: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
4231: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
4232: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
4233: l_remarks igs_pe_nonimg_form.remarks%TYPE;
4234: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
4235: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;

Line 4232: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;

4228: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
4229: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
4230: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
4231: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
4232: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
4233: l_remarks igs_pe_nonimg_form.remarks%TYPE;
4234: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
4235: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;
4236: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;

Line 4233: l_remarks igs_pe_nonimg_form.remarks%TYPE;

4229: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
4230: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
4231: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
4232: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
4233: l_remarks igs_pe_nonimg_form.remarks%TYPE;
4234: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
4235: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;
4236: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;
4237: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;

Line 5406: FROM igs_pe_nonimg_form

5402: l_months NUMBER(2);
5403: CURSOR c_get_visa_type
5404: IS
5405: SELECT visa_type
5406: FROM igs_pe_nonimg_form
5407: WHERE person_id = p_person_rec.person_id
5408: AND nonimg_form_id = p_person_rec.form_id;
5409:
5410: BEGIN

Line 5535: igs_pe_nonimg_form frm

5531: empl_party_id,
5532: action_code,
5533: NVL(em.print_flag, 'N') print_flag
5534: FROM igs_pe_nonimg_empl em,
5535: igs_pe_nonimg_form frm
5536: WHERE frm.person_id = cp_person_id
5537: AND frm.nonimg_form_id = em.nonimg_form_id
5538: ORDER BY nonimg_empl_id;
5539:

Line 7219: l_education_level igs_pe_nonimg_form.education_level%TYPE;

7215: l_tag_code VARCHAR2(30);
7216: l_edu_status VARCHAR2(10);
7217: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
7218:
7219: l_education_level igs_pe_nonimg_form.education_level%TYPE;
7220: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
7221: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
7222: l_minor igs_pe_nonimg_form.minor%TYPE;
7223: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

Line 7220: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;

7216: l_edu_status VARCHAR2(10);
7217: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
7218:
7219: l_education_level igs_pe_nonimg_form.education_level%TYPE;
7220: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
7221: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
7222: l_minor igs_pe_nonimg_form.minor%TYPE;
7223: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
7224: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;

Line 7221: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;

7217: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
7218:
7219: l_education_level igs_pe_nonimg_form.education_level%TYPE;
7220: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
7221: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
7222: l_minor igs_pe_nonimg_form.minor%TYPE;
7223: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
7224: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
7225: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;

Line 7222: l_minor igs_pe_nonimg_form.minor%TYPE;

7218:
7219: l_education_level igs_pe_nonimg_form.education_level%TYPE;
7220: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
7221: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
7222: l_minor igs_pe_nonimg_form.minor%TYPE;
7223: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
7224: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
7225: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
7226: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

Line 7223: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

7219: l_education_level igs_pe_nonimg_form.education_level%TYPE;
7220: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
7221: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
7222: l_minor igs_pe_nonimg_form.minor%TYPE;
7223: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
7224: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
7225: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
7226: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
7227: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

Line 7226: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

7222: l_minor igs_pe_nonimg_form.minor%TYPE;
7223: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
7224: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
7225: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
7226: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
7227: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
7228: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
7229: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
7230: l_position_code igs_pe_ev_form.position_code%TYPE;

Line 7227: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

7223: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
7224: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
7225: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
7226: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
7227: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
7228: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
7229: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
7230: l_position_code igs_pe_ev_form.position_code%TYPE;
7231: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

Line 7228: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

7224: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
7225: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
7226: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
7227: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
7228: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
7229: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
7230: l_position_code igs_pe_ev_form.position_code%TYPE;
7231: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
7232: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

Line 7229: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

7225: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
7226: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
7227: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
7228: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
7229: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
7230: l_position_code igs_pe_ev_form.position_code%TYPE;
7231: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
7232: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
7233:

Line 8276: FROM igs_pe_nonimg_form

8272: CURSOR c_ses_dates IS
8273: SELECT to_char(curr_session_end_date,'YYYY-MM-DD') ,
8274: to_char(next_session_start_date ,'YYYY-MM-DD'),
8275: last_session_flag
8276: FROM igs_pe_nonimg_form
8277: WHERE nonimg_form_id = p_person_rec.form_id;
8278:
8279: l_start_date igs_sv_persons.curr_session_end_date%TYPE;
8280: l_end_date igs_sv_persons.next_session_start_date%TYPE;

Line 8283: l_old_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;

8279: l_start_date igs_sv_persons.curr_session_end_date%TYPE;
8280: l_end_date igs_sv_persons.next_session_start_date%TYPE;
8281: l_old_start_date igs_sv_persons.curr_session_end_date%TYPE;
8282: l_old_end_date igs_sv_persons.next_session_start_date%TYPE;
8283: l_old_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;
8284: l_last_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;
8285: l_f_addr_rec g_address_rec_type;
8286: l_count NUMBER(10);
8287: l_changes_found VARCHAR2(1) := 'N'; --No changes by default

Line 8284: l_last_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;

8280: l_end_date igs_sv_persons.next_session_start_date%TYPE;
8281: l_old_start_date igs_sv_persons.curr_session_end_date%TYPE;
8282: l_old_end_date igs_sv_persons.next_session_start_date%TYPE;
8283: l_old_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;
8284: l_last_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;
8285: l_f_addr_rec g_address_rec_type;
8286: l_count NUMBER(10);
8287: l_changes_found VARCHAR2(1) := 'N'; --No changes by default
8288:

Line 11561: FROM igs_pe_nonimg_form fr, hz_parties pr

11557: GROUP BY pr.party_number,fr.person_id, fr.no_show_flag, fr.reprint_reason;
11558:
11559: CURSOR C_NI_CUR IS
11560: SELECT fr.person_id, min(nonimg_form_id) form_id, pr.party_number person_number, null no_show_flag, fr.reprint_reason reprint_reason
11561: FROM igs_pe_nonimg_form fr, hz_parties pr
11562: WHERE pr.party_id = fr.person_id
11563: AND fr.form_effective_date <= trunc(sysdate)
11564: AND fr.nonimg_form_id NOT IN
11565: ( SELECT st.nonimg_form_id FROM IGS_PE_NONIMG_STAT st

Line 11621: FROM igs_pe_nonimg_form

11617: AND batch_type = p_batch_type;
11618:
11619: CURSOR c_print_form (p_form_id NUMBER) IS
11620: SELECT decode(print_form,'Y','1','0') print_form
11621: FROM igs_pe_nonimg_form
11622: WHERE nonimg_form_id = p_form_id
11623: AND p_batch_type = 'I'
11624: UNION
11625: SELECT decode(print_form,'Y','1','0') print_form