DBA Data[Home] [Help]

APPS.IGS_AD_VAL_AA dependencies on IGS_AD_PRD_AD_PRC_CA

Line 347: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,

343: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number;
344: CURSOR c_adm_perd_adm_proc_cat (
345: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
346: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
347: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
348: cp_s_admission_process_type
349: IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
350: SELECT 'x'
351: FROM IGS_AD_PRD_AD_PRC_CA apapc

Line 349: IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS

345: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
346: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
347: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
348: cp_s_admission_process_type
349: IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
350: SELECT 'x'
351: FROM IGS_AD_PRD_AD_PRC_CA apapc
352: WHERE apapc.adm_cal_type = cp_adm_cal_type AND
353: apapc.adm_ci_sequence_number = cp_adm_ci_sequence_number AND

Line 351: FROM IGS_AD_PRD_AD_PRC_CA apapc

347: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
348: cp_s_admission_process_type
349: IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
350: SELECT 'x'
351: FROM IGS_AD_PRD_AD_PRC_CA apapc
352: WHERE apapc.adm_cal_type = cp_adm_cal_type AND
353: apapc.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
354: apapc.admission_cat = cp_admission_cat AND
355: apapc.s_admission_process_type = cp_s_admission_process_type AND