DBA Data[Home] [Help]

APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on IGF_AW_LOOKUPS_VIEW

Line 3050: l_lookup_type igf_aw_lookups_view.lookup_type%TYPE;

3046: || Who When What
3047: || (reverse chronological order - newest change first)
3048: */
3049: l_hash_value NUMBER;
3050: l_lookup_type igf_aw_lookups_view.lookup_type%TYPE;
3051: BEGIN
3052:
3053:
3054: l_hash_value := DBMS_UTILITY.get_hash_value(

Line 3098: FROM IGF_AW_LOOKUPS_VIEW

3094: p_award_year VARCHAR2 )
3095: IS
3096:
3097: SELECT LOOKUP_CODE
3098: FROM IGF_AW_LOOKUPS_VIEW
3099: WHERE LOOKUP_TYPE = p_lookup_type
3100: AND SYS_AWARD_YEAR =p_award_year
3101: AND enabled_flag = 'Y' ;
3102:

Line 5855: FROM igf_aw_lookups_view

5851: AND map.ci_sequence_number = p_ci_sequence_number ;
5852:
5853: CURSOR c_lkup_values(p_lookup_code VARCHAR2 )IS
5854: SELECT meaning
5855: FROM igf_aw_lookups_view
5856: WHERE lookup_type ='IGF_AW_LOOKUPS_MSG'
5857: AND lookup_code =p_lookup_code
5858: AND enabled_flag = 'Y' ;
5859: