APPS.IGS_AD_IMP_PRBLTY_VAL_PKG dependencies on IGS_AD_RECRUIT_PI_V

Line 23: FROM igs_ad_recruit_pi_v

19:
20: --Cursor to check for duplicate record
21: CURSOR duplicate_check_cur IS
22: SELECT 'X'
23: FROM igs_ad_recruit_pi_v
24: WHERE person_id = p_person_id AND
25: TRUNC(calculation_date) = TRUNC(p_calculation_date) AND
26: probability_type_code_id = p_prblty_type_code_id;
27:

Line 266: FROM igs_ad_recruit_pi_v

262: CURSOR null_hdlg_adm_recrt_pi_cur(c_person_id igs_ad_recrt_pi_int.person_id%TYPE,
263: c_calculation_date igs_ad_recrt_pi_int.calculation_date%TYPE,
264: c_prblty_type_code_id igs_ad_recrt_pi_int.prblty_type_code_id%TYPE) IS
265: SELECT *
266: FROM igs_ad_recruit_pi_v
267: WHERE person_id = c_person_id AND
268: calculation_date = c_calculation_date AND
269: probability_type_code_id = c_prblty_type_code_id;
270: