APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_HE_SUBMSN_RETURN

Line 8: g_he_submsn_return igs_he_submsn_return%ROWTYPE;

4: -- Variables that will be accessed by any or all the procedures
5: -- Extract related records
6: g_he_ext_run_dtls igs_he_ext_run_dtls%ROWTYPE;
7: g_he_ext_run_except igs_he_ext_run_excp%ROWTYPE;
8: g_he_submsn_return igs_he_submsn_return%ROWTYPE;
9: g_he_submsn_header igs_he_submsn_header%ROWTYPE;
10:
11: -- Student / Module related records.
12: g_en_stdnt_ps_att igs_en_stdnt_ps_att%ROWTYPE;

Line 579: igs_he_submsn_return b,

575: c.validation_country,
576: c.apply_to_atmpt_st_dt,
577: c.apply_to_inst_st_dt
578: FROM igs_he_ext_run_dtls a,
579: igs_he_submsn_return b,
580: igs_he_submsn_header c
581: WHERE a.extract_run_id = p_extract_run_id
582: AND a.submission_name = b.submission_name
583: AND a.return_name = b.return_name

Line 10465: CURSOR c_dlhe_dtls(cp_submission_name igs_he_submsn_return.submission_name%TYPE ,

10461: Change History :
10462: Who When What
10463:
10464: ***************************************************************/
10465: CURSOR c_dlhe_dtls(cp_submission_name igs_he_submsn_return.submission_name%TYPE ,
10466: cp_return_name igs_he_submsn_return.return_name%TYPE ) IS
10467: SELECT *
10468: FROM igs_he_stdnt_dlhe
10469: WHERE person_id = p_person_id

Line 10466: cp_return_name igs_he_submsn_return.return_name%TYPE ) IS

10462: Who When What
10463:
10464: ***************************************************************/
10465: CURSOR c_dlhe_dtls(cp_submission_name igs_he_submsn_return.submission_name%TYPE ,
10466: cp_return_name igs_he_submsn_return.return_name%TYPE ) IS
10467: SELECT *
10468: FROM igs_he_stdnt_dlhe
10469: WHERE person_id = p_person_id
10470: AND submission_name = cp_submission_name