APPS.IGS_AD_ADM_REQ dependencies on IGS_PE_MIL_SERVICES

Line 832: CURSOR c_igs_pe_mil_services IS

828: SELECT row_id
829: FROM igs_pe_person_addr
830: WHERE person_id = p_person_id;
831:
832: CURSOR c_igs_pe_mil_services IS
833: SELECT row_id
834: FROM igs_pe_mil_services
835: WHERE person_id = p_person_id;
836:

Line 834: FROM igs_pe_mil_services

830: WHERE person_id = p_person_id;
831:
832: CURSOR c_igs_pe_mil_services 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

Line 1016: lv_rowid_mil_serv igs_pe_mil_services.row_id%TYPE;

1012: lv_tmp_trk TRK_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;

Line 1203: OPEN c_igs_pe_mil_services;

1199: END IF;
1200: END IF;
1201:
1202: IF rowid_mil_serv_table.count = 0 AND l_military_rule_exists THEN
1203: OPEN c_igs_pe_mil_services;
1204: FETCH c_igs_pe_mil_services BULK COLLECT INTO rowid_mil_serv_table ;
1205: IF c_igs_pe_mil_services%ISOPEN THEN
1206: CLOSE c_igs_pe_mil_services;
1207: END IF;

Line 1204: FETCH c_igs_pe_mil_services BULK COLLECT INTO rowid_mil_serv_table ;

1200: END IF;
1201:
1202: IF rowid_mil_serv_table.count = 0 AND l_military_rule_exists THEN
1203: OPEN c_igs_pe_mil_services;
1204: FETCH c_igs_pe_mil_services BULK COLLECT INTO rowid_mil_serv_table ;
1205: IF c_igs_pe_mil_services%ISOPEN THEN
1206: CLOSE c_igs_pe_mil_services;
1207: END IF;
1208: END IF;

Line 1205: IF c_igs_pe_mil_services%ISOPEN THEN

1201:
1202: IF rowid_mil_serv_table.count = 0 AND l_military_rule_exists THEN
1203: OPEN c_igs_pe_mil_services;
1204: FETCH c_igs_pe_mil_services BULK COLLECT INTO rowid_mil_serv_table ;
1205: IF c_igs_pe_mil_services%ISOPEN THEN
1206: CLOSE c_igs_pe_mil_services;
1207: END IF;
1208: END IF;
1209:

Line 1206: CLOSE c_igs_pe_mil_services;

1202: IF rowid_mil_serv_table.count = 0 AND l_military_rule_exists THEN
1203: OPEN c_igs_pe_mil_services;
1204: FETCH c_igs_pe_mil_services BULK COLLECT INTO rowid_mil_serv_table ;
1205: IF c_igs_pe_mil_services%ISOPEN THEN
1206: CLOSE c_igs_pe_mil_services;
1207: END IF;
1208: END IF;
1209:
1210: