APPS.IGF_AP_ISIR_IMPORT_PKG dependencies on IGF_LOOKUPS_VIEW

Line 77: FROM igf_lookups_view

73: IS
74:
75: CURSOR c_msg_class( p_lookup_type VARCHAR2, p_lookup_code VARCHAR2 ) IS
76: SELECT LOOKUP_CODE
77: FROM igf_lookups_view
78: WHERE lookup_type = p_lookup_type
79: AND tag = p_lookup_code
80: AND enabled_flag = 'Y';
81:

Line 327: CURSOR cur_lookups(cp_lkup_type igf_lookups_view.lookup_type%TYPE,

323: SELECT 'Y'
324: FROM igf_ap_batch_aw_map
325: WHERE batch_year = cp_batch_yr;
326:
327: CURSOR cur_lookups(cp_lkup_type igf_lookups_view.lookup_type%TYPE,
328: cp_lkup_code igf_lookups_view.lookup_code%TYPE) IS
329: SELECT 'Y'
330: FROM igf_lookups_view
331: WHERE lookup_type = cp_lkup_type

Line 328: cp_lkup_code igf_lookups_view.lookup_code%TYPE) IS

324: FROM igf_ap_batch_aw_map
325: WHERE batch_year = cp_batch_yr;
326:
327: CURSOR cur_lookups(cp_lkup_type igf_lookups_view.lookup_type%TYPE,
328: cp_lkup_code igf_lookups_view.lookup_code%TYPE) IS
329: SELECT 'Y'
330: FROM igf_lookups_view
331: WHERE lookup_type = cp_lkup_type
332: AND lookup_code = cp_lkup_code

Line 330: FROM igf_lookups_view

326:
327: CURSOR cur_lookups(cp_lkup_type igf_lookups_view.lookup_type%TYPE,
328: cp_lkup_code igf_lookups_view.lookup_code%TYPE) IS
329: SELECT 'Y'
330: FROM igf_lookups_view
331: WHERE lookup_type = cp_lkup_type
332: AND lookup_code = cp_lkup_code
333: AND enabled_flag = 'Y';
334:

Line 1577: igf_lookups_view lkup

1573: FROM igf_ap_batch_aw_map map,
1574: igf_ap_fa_base_rec_all fabase,
1575: igf_ap_ISIR_corr corr,
1576: Igf_fc_sar_cd_mst sar ,
1577: igf_lookups_view lkup
1578: WHERE fabase.base_id = cp_base_id
1579: AND map.ci_cal_type = fabase.ci_cal_type
1580: AND map.ci_sequence_number = fabase.ci_sequence_number
1581: AND sar.sys_award_year = map.sys_award_year

Line 1595: lv_column_meaning igf_lookups_view.meaning%TYPE ;

1591: lv_retval igf_ap_ISIR_corr.original_value%TYPE;
1592: lv_stmt VARCHAR2(2000);
1593: lv_rows integer;
1594: lv_column_name VARCHAR2(30);
1595: lv_column_meaning igf_lookups_view.meaning%TYPE ;
1596: ln_count_corr NUMBER := 99999;
1597: l_corr_stat VARCHAR2(30) ;
1598: ln_isir_id igf_ap_isir_matched.isir_id%TYPE;
1599: l_lkup_type VARCHAR2(60);