APPS.IGS_PE_GEN_004 dependencies on IGS_PE_FELONY_DTLS

Line 650: CURSOR records_null_dtls_cur (cp_person_id igs_pe_felony_dtls.person_id%TYPE) IS

646: Change History:
647: Who When What
648:
649: */
650: CURSOR records_null_dtls_cur (cp_person_id igs_pe_felony_dtls.person_id%TYPE) IS
651: SELECT 'X'
652: FROM igs_pe_felony_dtls
653: WHERE person_id=cp_person_id;
654:

Line 652: FROM igs_pe_felony_dtls

648:
649: */
650: CURSOR records_null_dtls_cur (cp_person_id igs_pe_felony_dtls.person_id%TYPE) IS
651: SELECT 'X'
652: FROM igs_pe_felony_dtls
653: WHERE person_id=cp_person_id;
654:
655: CURSOR records_no_dtls_cur (cp_person_id igs_pe_felony_dtls.person_id%TYPE) IS
656: SELECT 'X'

Line 655: CURSOR records_no_dtls_cur (cp_person_id igs_pe_felony_dtls.person_id%TYPE) IS

651: SELECT 'X'
652: FROM igs_pe_felony_dtls
653: WHERE person_id=cp_person_id;
654:
655: CURSOR records_no_dtls_cur (cp_person_id igs_pe_felony_dtls.person_id%TYPE) IS
656: SELECT 'X'
657: FROM igs_pe_felony_dtls
658: WHERE person_id=cp_person_id
659: AND convict_ind='Y';

Line 657: FROM igs_pe_felony_dtls

653: WHERE person_id=cp_person_id;
654:
655: CURSOR records_no_dtls_cur (cp_person_id igs_pe_felony_dtls.person_id%TYPE) IS
656: SELECT 'X'
657: FROM igs_pe_felony_dtls
658: WHERE person_id=cp_person_id
659: AND convict_ind='Y';
660:
661: l_race_null_dtls_rec VARCHAR2(1);