APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_HE_SUBMSN_RETURN

Line 6: g_he_submsn_return igs_he_submsn_return%ROWTYPE;

2: /* $Header: IGSHE27B.pls 120.3 2006/06/21 03:00:01 jchin noship $*/
3:
4:
5: -- Global variables
6: g_he_submsn_return igs_he_submsn_return%ROWTYPE;
7: g_he_submsn_header igs_he_submsn_header%ROWTYPE;
8:
9:
10:

Line 889: igs_he_submsn_return rtn

885: shd.enrolment_end_date,
886: shd.offset_days,
887: NVL(shd.apply_to_atmpt_st_dt,'N') apply_to_atmpt_st_dt
888: FROM igs_he_submsn_header shd,
889: igs_he_submsn_return rtn
890: WHERE rtn.sub_rtn_id = p_sub_rtn_id
891: AND rtn.submission_name = shd.submission_name;
892:
893: l_request_id NUMBER;