DBA Data[Home] [Help]

APPS.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_HE_USR_RTN_CLAS

Line 32: igs_he_usr_rtn_clas urc

28: qual.qual_period_start_date,
29: qual.qual_period_end_date,
30: qual.closed_ind
31: FROM igs_he_sub_rtn_qual qual,
32: igs_he_usr_rtn_clas urc
33: WHERE qual.submission_name = cp_submission_name
34: AND qual.return_name = cp_return_name
35: AND qual.qual_period_code = NVL(cp_qual_period, qual.qual_period_code)
36: AND qual.qual_period_type IN ('L','R')

Line 421: igs_he_usr_rtn_clas urc

417: qual.qual_period_end_date,
418: qual.user_return_subclass,
419: qual.closed_ind
420: FROM igs_he_sub_rtn_qual qual,
421: igs_he_usr_rtn_clas urc
422: WHERE qual.submission_name = cp_submission_name
423: AND qual.return_name = cp_return_name
424: AND qual.qual_period_code = cp_qual_period_code
425: AND qual.user_return_subclass = urc.user_return_subclass