APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_STDNT_DLHE

Line 1980: p_dlhe_record_status igs_he_stdnt_dlhe.dlhe_record_status%TYPE,

1976:
1977: --smaddali created this procedure for validating dlhe record status , HEFD203 build, bug#2717745
1978: -- smaddali 16-oct-03 Modified the processing of dlhe_status parameters as part of bug#3166126
1979: FUNCTION validate_dlhe_status (p_extract_run_id IN NUMBER,
1980: p_dlhe_record_status igs_he_stdnt_dlhe.dlhe_record_status%TYPE,
1981: p_popdlhe_flag igs_he_stdnt_dlhe.popdlhe_flag%TYPE)
1982: RETURN BOOLEAN
1983: IS
1984: /***************************************************************

Line 1981: p_popdlhe_flag igs_he_stdnt_dlhe.popdlhe_flag%TYPE)

1977: --smaddali created this procedure for validating dlhe record status , HEFD203 build, bug#2717745
1978: -- smaddali 16-oct-03 Modified the processing of dlhe_status parameters as part of bug#3166126
1979: FUNCTION validate_dlhe_status (p_extract_run_id IN NUMBER,
1980: p_dlhe_record_status igs_he_stdnt_dlhe.dlhe_record_status%TYPE,
1981: p_popdlhe_flag igs_he_stdnt_dlhe.popdlhe_flag%TYPE)
1982: RETURN BOOLEAN
1983: IS
1984: /***************************************************************
1985: Created By : smaddali

Line 2101: FROM igs_he_stdnt_dlhe dlhe,

2097: p_return_name igs_he_submsn_return.return_name%TYPE,
2098: p_user_return_subclass igs_he_submsn_return.user_return_subclass%TYPE )
2099: IS
2100: SELECT dlhe.person_id , dlhe.dlhe_record_status, dlhe.popdlhe_flag
2101: FROM igs_he_stdnt_dlhe dlhe,
2102: igs_he_sub_rtn_qual qual
2103: WHERE qual.submission_name = dlhe.submission_name
2104: AND qual.return_name = dlhe.return_name
2105: AND qual.user_return_subclass = dlhe.user_return_subclass