DBA Data[Home] [Help]

APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on IGF_AW_LOOKUPS_VIEW

Line 3180: FROM IGF_AW_LOOKUPS_VIEW

3176: p_award_year VARCHAR2 )
3177: IS
3178:
3179: SELECT LOOKUP_CODE
3180: FROM IGF_AW_LOOKUPS_VIEW
3181: WHERE LOOKUP_TYPE = p_lookup_type
3182: AND SYS_AWARD_YEAR =p_award_year
3183: AND enabled_flag = 'Y' ;
3184:

Line 3229: l_lookup_type igf_aw_lookups_view. lookup_type%TYPE;

3225: || Who When What
3226: || (reverse chronological order - newest change first)
3227: */
3228: l_hash_value NUMBER;
3229: l_lookup_type igf_aw_lookups_view. lookup_type%TYPE;
3230: BEGIN
3231:
3232:
3233: l_hash_value := dbms_utility.get_hash_value(

Line 4015: FROM igf_aw_lookups_view

4011:
4012: CURSOR c_lkup_values(p_lookup_code VARCHAR2 )
4013: IS
4014: SELECT meaning
4015: FROM igf_aw_lookups_view
4016: WHERE lookup_type ='IGF_AW_LOOKUPS_MSG'
4017: AND lookup_code =p_lookup_code
4018: AND enabled_flag = 'Y' ;
4019:

Line 5923: FROM igf_aw_lookups_view

5919:
5920: CURSOR c_lkup_values(p_lookup_code VARCHAR2 )
5921: IS
5922: SELECT meaning
5923: FROM igf_aw_lookups_view
5924: WHERE lookup_type ='IGF_AW_LOOKUPS_MSG'
5925: AND lookup_code =p_lookup_code
5926: AND enabled_flag = 'Y' ;
5927: