APPS.IGS_AD_ADM_REQ dependencies on IGS_PE_CITIZENSHIP_V

Line 851: CURSOR c_igs_pe_citizenship_v IS

847: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);
848:
849:
850:
851: CURSOR c_igs_pe_citizenship_v IS
852: SELECT row_id
853: FROM igs_pe_citizenship_v
854: WHERE party_id = p_person_id;
855:

Line 853: FROM igs_pe_citizenship_v

849:
850:
851: CURSOR c_igs_pe_citizenship_v IS
852: SELECT row_id
853: FROM igs_pe_citizenship_v
854: WHERE party_id = p_person_id;
855:
856: CURSOR c_igs_pe_res_dtls IS
857: SELECT row_id

Line 1020: lv_rowid_pe_ctz igs_pe_citizenship_v.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;
1022: lv_rowid_pe_teach igs_pe_teach_periods_v.row_id%TYPE;
1023: lv_rowid_tst_rslt igs_ad_tst_rslt_dtls_v.row_id%TYPE;
1024: lv_rowid_acad_hist igs_ad_acad_history_v.row_id%TYPE;

Line 1229: OPEN c_igs_pe_citizenship_v;

1225: END IF;
1226: END IF;
1227:
1228: IF rowid_pe_ctz_table.count = 0 AND l_citizenship_rule_exists THEN
1229: OPEN c_igs_pe_citizenship_v;
1230: FETCH c_igs_pe_citizenship_v BULK COLLECT INTO rowid_pe_ctz_table ;
1231: IF c_igs_pe_citizenship_v%ISOPEN THEN
1232: CLOSE c_igs_pe_citizenship_v;
1233: END IF;

Line 1230: FETCH c_igs_pe_citizenship_v BULK COLLECT INTO rowid_pe_ctz_table ;

1226: END IF;
1227:
1228: IF rowid_pe_ctz_table.count = 0 AND l_citizenship_rule_exists THEN
1229: OPEN c_igs_pe_citizenship_v;
1230: FETCH c_igs_pe_citizenship_v BULK COLLECT INTO rowid_pe_ctz_table ;
1231: IF c_igs_pe_citizenship_v%ISOPEN THEN
1232: CLOSE c_igs_pe_citizenship_v;
1233: END IF;
1234: END IF;

Line 1231: IF c_igs_pe_citizenship_v%ISOPEN THEN

1227:
1228: IF rowid_pe_ctz_table.count = 0 AND l_citizenship_rule_exists THEN
1229: OPEN c_igs_pe_citizenship_v;
1230: FETCH c_igs_pe_citizenship_v BULK COLLECT INTO rowid_pe_ctz_table ;
1231: IF c_igs_pe_citizenship_v%ISOPEN THEN
1232: CLOSE c_igs_pe_citizenship_v;
1233: END IF;
1234: END IF;
1235:

Line 1232: CLOSE c_igs_pe_citizenship_v;

1228: IF rowid_pe_ctz_table.count = 0 AND l_citizenship_rule_exists THEN
1229: OPEN c_igs_pe_citizenship_v;
1230: FETCH c_igs_pe_citizenship_v BULK COLLECT INTO rowid_pe_ctz_table ;
1231: IF c_igs_pe_citizenship_v%ISOPEN THEN
1232: CLOSE c_igs_pe_citizenship_v;
1233: END IF;
1234: END IF;
1235:
1236: IF rowid_pe_res_table.count = 0 AND l_pe_results_rule_exists THEN