APPS.IGS_AD_ADM_REQ dependencies on IGS_PE_PERS_DISABLTY_V

Line 837: CURSOR c_igs_pe_pers_disablty_v IS

833: SELECT row_id
834: FROM igs_pe_mil_services
835: WHERE person_id = p_person_id;
836:
837: CURSOR c_igs_pe_pers_disablty_v IS
838: SELECT rowid row_id
839: FROM igs_pe_pers_disablty
840: WHERE person_id = p_person_id;
841:

Line 1017: lv_rowid_pers_dis igs_pe_pers_disablty_v.row_id%TYPE;

1013: lv_emp_trk TRK_TYPE;
1014:
1015: lv_rowid_per_addr igs_pe_person_addr.row_id%TYPE;
1016: lv_rowid_mil_serv igs_pe_mil_services.row_id%TYPE;
1017: lv_rowid_pers_dis igs_pe_pers_disablty_v.row_id%TYPE;
1018: -- lv_rowid_pe_stat igs_pe_stat_v.row_id%TYPE;
1019: lv_rowid_pe_citizen_status igs_pe_eit_restatus_v.row_id%TYPE;
1020: lv_rowid_pe_ctz igs_pe_citizenship_v.row_id%TYPE;
1021: lv_rowid_pe_res igs_pe_res_dtls.row_id%TYPE;

Line 1212: OPEN c_igs_pe_pers_disablty_v;

1208: END IF;
1209:
1210:
1211: IF rowid_pers_dis_table.count = 0 AND l_pers_disability_rule_exists THEN
1212: OPEN c_igs_pe_pers_disablty_v;
1213: FETCH c_igs_pe_pers_disablty_v BULK COLLECT INTO rowid_pers_dis_table ;
1214: IF c_igs_pe_pers_disablty_v%ISOPEN THEN
1215: CLOSE c_igs_pe_pers_disablty_v;
1216: END IF;

Line 1213: FETCH c_igs_pe_pers_disablty_v BULK COLLECT INTO rowid_pers_dis_table ;

1209:
1210:
1211: IF rowid_pers_dis_table.count = 0 AND l_pers_disability_rule_exists THEN
1212: OPEN c_igs_pe_pers_disablty_v;
1213: FETCH c_igs_pe_pers_disablty_v BULK COLLECT INTO rowid_pers_dis_table ;
1214: IF c_igs_pe_pers_disablty_v%ISOPEN THEN
1215: CLOSE c_igs_pe_pers_disablty_v;
1216: END IF;
1217: END IF;

Line 1214: IF c_igs_pe_pers_disablty_v%ISOPEN THEN

1210:
1211: IF rowid_pers_dis_table.count = 0 AND l_pers_disability_rule_exists THEN
1212: OPEN c_igs_pe_pers_disablty_v;
1213: FETCH c_igs_pe_pers_disablty_v BULK COLLECT INTO rowid_pers_dis_table ;
1214: IF c_igs_pe_pers_disablty_v%ISOPEN THEN
1215: CLOSE c_igs_pe_pers_disablty_v;
1216: END IF;
1217: END IF;
1218:

Line 1215: CLOSE c_igs_pe_pers_disablty_v;

1211: IF rowid_pers_dis_table.count = 0 AND l_pers_disability_rule_exists THEN
1212: OPEN c_igs_pe_pers_disablty_v;
1213: FETCH c_igs_pe_pers_disablty_v BULK COLLECT INTO rowid_pers_dis_table ;
1214: IF c_igs_pe_pers_disablty_v%ISOPEN THEN
1215: CLOSE c_igs_pe_pers_disablty_v;
1216: END IF;
1217: END IF;
1218:
1219: