APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_LOOKUPS_VIEW

Line 1320: FROM igf_lookups_view lkup

1316:
1317: CURSOR cur_get_sar_field_desc (pv_column_name igf_fc_sar_cd_mst.sar_field_name%TYPE,
1318: pv_lookup_type VARCHAR2) IS
1319: SELECT lkup.meaning
1320: FROM igf_lookups_view lkup
1321: WHERE lkup.lookup_type = pv_lookup_type
1322: AND lkup.lookup_code = pv_column_name
1323: AND lkup.enabled_flag = 'Y' ;
1324:

Line 1327: l_sar_col_desc igf_lookups_view.meaning%TYPE ;

1323: AND lkup.enabled_flag = 'Y' ;
1324:
1325: l_column_name igf_fc_sar_cd_mst.sar_field_name%TYPE ;
1326: l_lookup_type VARCHAR2(60) ;
1327: l_sar_col_desc igf_lookups_view.meaning%TYPE ;
1328:
1329: BEGIN
1330:
1331: IF pv_column_name <> 'S_EMAIL_ADDRESS' THEN

Line 1948: pv_fed_verif_status igf_lookups_view.lookup_code%TYPE,

1944:
1945: END update_fed_verif_status;
1946:
1947: FUNCTION get_gr_ver_code(
1948: pv_fed_verif_status igf_lookups_view.lookup_code%TYPE,
1949: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,
1950: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE
1951: ) RETURN VARCHAR2 IS
1952:

Line 1967: p_fed_verif_status igf_lookups_view.lookup_code%TYPE,

1963: lv_sys_award_year igf_aw_int_ext_map.sys_award_year%TYPE;
1964:
1965: -- Read mapping from igf_aw_int_ext_map table
1966: CURSOR cur_get_int_ext(
1967: p_fed_verif_status igf_lookups_view.lookup_code%TYPE,
1968: p_sys_award_year igf_aw_int_ext_map.sys_award_year%TYPE ,
1969: cp_int_lkup_type VARCHAR2 ,
1970: cp_ext_lkup_type VARCHAR2
1971: ) IS