APPS.IGS_AD_PNMEMBR_DTLS_PKG dependencies on IGS_AD_INTVW_PNLS

Line 480: FROM igs_ad_intvw_pnls pnls,

476: instance_dets_rec c_instance_dets%ROWTYPE;
477:
478: CURSOR c_intvw_pnl_exsts (cp_instance_rec c_instance_dets%ROWTYPE ) IS
479: SELECT 'X'
480: FROM igs_ad_intvw_pnls pnls,
481: igs_ad_panel_dtls pdtls
482: WHERE pnls.panel_type_code='INTERVIEW'
483: AND pnls.panel_code = pdtls.panel_code
484: AND pdtls.person_id = cp_instance_rec.person_id

Line 492: CURSOR cur_dflt_panlm_cd(cp_panel_type_code igs_ad_intvw_pnls.panel_type_code%TYPE) IS

488:
489: intvw_pnl_exsts_rec c_intvw_pnl_exsts%ROWTYPE;
490:
491: -- Cursor to get the system defaulted Decisions mapped to 'PENDING'
492: CURSOR cur_dflt_panlm_cd(cp_panel_type_code igs_ad_intvw_pnls.panel_type_code%TYPE) IS
493: SELECT *
494: FROM igs_ad_code_classes
495: WHERE system_status = 'PENDING'
496: AND class = cp_panel_type_code --'INTERVIEW', 'SCREENING', 'FINAL_SCREENING', 'FINAL_INTERVIEW'

Line 506: FROM igs_ad_intvw_pnls ip,

502:
503: --get the panel type code
504: CURSOR c_panel_type_code IS
505: SELECT ip.panel_type_Code
506: FROM igs_ad_intvw_pnls ip,
507: igs_ad_panel_dtls pd
508: WHERE ip.panel_code = pd.panel_code
509: AND pd.panel_dtls_id = new_references.panel_dtls_id;
510:

Line 511: l_panel_type_Code igs_ad_intvw_pnls.panel_type_Code%TYPE;

507: igs_ad_panel_dtls pd
508: WHERE ip.panel_code = pd.panel_code
509: AND pd.panel_dtls_id = new_references.panel_dtls_id;
510:
511: l_panel_type_Code igs_ad_intvw_pnls.panel_type_Code%TYPE;
512:
513: -- Cursor to get the meaning for lookup code
514: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
515: SELECT meaning