APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_CODE_VALUES

Line 864: FROM igs_he_code_values hecodeval

860:
861: -- anwest 09-Dec-2004 HE356 - created this new cursor
862: CURSOR cur_res_val (cp_res_stat_cd VARCHAR2) IS
863: SELECT 'X'
864: FROM igs_he_code_values hecodeval
865: WHERE hecodeval.code_type = 'OSS_RESIDENCY_OS'
866: AND hecodeval.value = cp_res_stat_cd
867: AND NVL(hecodeval.closed_ind,'N') = 'N' ;
868:

Line 1773: igs_he_code_values d

1769: SELECT MAX( site_use_type)
1770: FROM igs_pe_partysiteuse_v a,
1771: hz_party_sites b,
1772: igs_pe_hz_pty_sites c,
1773: igs_he_code_values d
1774: WHERE a.party_site_id = b.party_site_id
1775: AND b.party_site_id = c.party_site_id(+)
1776: AND (b.status = 'A'
1777: AND ( c.Start_Date IS NULL OR c.Start_Date <= p_enrl_end_dt )

Line 2551: p_oss_qualaim_sbj IN igs_he_code_values.value%TYPE,

2547: PROCEDURE get_qual_aim_sbj1
2548: (p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,
2549: p_qual_aim_subj2 IN igs_he_st_spa.qual_aim_subj2%TYPE,
2550: p_qual_aim_subj3 IN igs_he_st_spa.qual_aim_subj3%TYPE,
2551: p_oss_qualaim_sbj IN igs_he_code_values.value%TYPE,
2552: p_hesa_qualaim_sbj OUT NOCOPY igs_he_code_values.value%TYPE
2553: )
2554: IS
2555: /***************************************************************

Line 2552: p_hesa_qualaim_sbj OUT NOCOPY igs_he_code_values.value%TYPE

2548: (p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,
2549: p_qual_aim_subj2 IN igs_he_st_spa.qual_aim_subj2%TYPE,
2550: p_qual_aim_subj3 IN igs_he_st_spa.qual_aim_subj3%TYPE,
2551: p_oss_qualaim_sbj IN igs_he_code_values.value%TYPE,
2552: p_hesa_qualaim_sbj OUT NOCOPY igs_he_code_values.value%TYPE
2553: )
2554: IS
2555: /***************************************************************
2556: Created By : bayadav

Line 3682: igs_he_code_values d,

3678: FROM igf_aw_awd_disb a,
3679: igf_aw_award b,
3680: igf_aw_fund_mast fmast,
3681: igf_ap_fa_base_rec c,
3682: igs_he_code_values d,
3683: igs_ca_inst ca
3684: WHERE a.award_id = b.award_id
3685: AND b.fund_id = fmast.fund_id
3686: AND b.base_id = c.base_id

Line 3721: igs_he_code_values d,

3717: FROM igf_aw_awd_disb a,
3718: igf_aw_award b,
3719: igf_aw_fund_mast fmast,
3720: igf_ap_fa_base_rec c,
3721: igs_he_code_values d,
3722: igs_ca_inst ca
3723: WHERE a.award_id = b.award_id
3724: AND b.fund_id = fmast.fund_id
3725: AND b.base_id = c.base_id

Line 6710: FROM igs_he_code_values b

6706: SELECT a.approved_result, a.grading_schema_cd
6707: FROM igs_uc_qual_dets a
6708: WHERE a.person_id = p_person_id
6709: AND EXISTS (SELECT 'X'
6710: FROM igs_he_code_values b
6711: WHERE b.value = a.exam_level
6712: AND b.code_type = 'OSS_QUAL_1ST_DEGREE'
6713: AND NVL(b.closed_ind,'N') = 'N' )
6714: ORDER BY a.year DESC;