10: BEGIN -- admp_val_eapmpi_dt
11: -- Description: Validate the IGS_IN_APPLML_PKGITM.mailed_dt.
12: -- * The mailed_dt must be >= to the IGS_IN_ENQUIRY_APPL.enquiry_dt.
13: DECLARE
14: v_ea_rec IGR_I_APPL_ALL.enquiry_dt%TYPE;
15: CURSOR c_ea IS
16: SELECT ea.enquiry_dt
17: FROM IGR_I_APPL_ALL ea
18: WHERE ea.person_id = p_person_id AND
13: DECLARE
14: v_ea_rec IGR_I_APPL_ALL.enquiry_dt%TYPE;
15: CURSOR c_ea IS
16: SELECT ea.enquiry_dt
17: FROM IGR_I_APPL_ALL ea
18: WHERE ea.person_id = p_person_id AND
19: ea.enquiry_appl_number = p_enquiry_appl_number AND
20: TRUNC(ea.enquiry_dt) <= p_mailed_dt;
21: BEGIN