APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_BATCH_AW_MAP

Line 1459: FROM igf_ap_batch_aw_map map,

1455:
1456: CURSOR cur_get_ver_data ( pn_base_id NUMBER ) IS
1457: SELECT ivi.base_id, ivi.udf_vern_item_seq_num, ivi.item_value, ivi.isir_map_col,
1458: ivi.incl_in_tolerance, sar.sar_field_name column_name
1459: FROM igf_ap_batch_aw_map map,
1460: igf_ap_fa_base_rec_all fabase,
1461: igf_ap_inst_ver_item ivi,
1462: Igf_fc_sar_cd_mst sar
1463: WHERE fabase.base_id = pn_base_id

Line 1499: FROM igf_ap_batch_aw_map

1495: cp_cal_type VARCHAR2,
1496: cp_sequence_number NUMBER
1497: ) IS
1498: SELECT sys_award_year
1499: FROM igf_ap_batch_aw_map
1500: WHERE ci_cal_type = cp_cal_type
1501: AND ci_sequence_number = cp_sequence_number ;
1502:
1503: lv_get_sys_year c_get_sys_year%ROWTYPE;

Line 1949: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,

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:
1953: -- Read Sys Award Year

Line 1950: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE

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:
1953: -- Read Sys Award Year
1954: CURSOR cur_get_sys_awd(

Line 1955: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,

1951: ) RETURN VARCHAR2 IS
1952:
1953: -- Read Sys Award Year
1954: CURSOR cur_get_sys_awd(
1955: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,
1956: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE
1957: ) IS
1958: SELECT sys_award_year
1959: FROM igf_ap_batch_aw_map

Line 1956: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE

1952:
1953: -- Read Sys Award Year
1954: CURSOR cur_get_sys_awd(
1955: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,
1956: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE
1957: ) IS
1958: SELECT sys_award_year
1959: FROM igf_ap_batch_aw_map
1960: WHERE ci_cal_type = p_cal_type

Line 1959: FROM igf_ap_batch_aw_map

1955: p_cal_type igf_ap_batch_aw_map_all.ci_cal_type%TYPE,
1956: p_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE
1957: ) IS
1958: SELECT sys_award_year
1959: FROM igf_ap_batch_aw_map
1960: WHERE ci_cal_type = p_cal_type
1961: AND ci_sequence_number = p_sequence_number;
1962:
1963: lv_sys_award_year igf_aw_int_ext_map.sys_award_year%TYPE;