APPS.IGF_AP_VER_GRPS_PRC_PKG dependencies on IGF_FC_SAR_CD_MST

Line 67: Igf_fc_sar_cd_mst sar ,

63: cp_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE,
64: cp_lkup_type VARCHAR2 ) IS
65: SELECT lkup.meaning meaning
66: FROM igf_ap_batch_aw_map map,
67: Igf_fc_sar_cd_mst sar ,
68: igf_lookups_view lkup
69: WHERE map.ci_cal_type = cp_ci_cal_type
70: AND map.ci_sequence_number = cp_ci_sequence_number
71: AND sar.sys_award_year = map.sys_award_year

Line 408: l_isir_map_col igf_fc_sar_cd_mst.sar_field_number%TYPE;

404: */
405:
406: lv_rowid ROWID := NULL ;
407: lv_meaning igf_lookups_view.meaning%TYPE;
408: l_isir_map_col igf_fc_sar_cd_mst.sar_field_number%TYPE;
409: CURSOR cur_isir_desc (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,
410: lv_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE,
411: cp_lkup_type VARCHAR2 ) IS
412: SELECT sar.sar_field_number isir_map_col, lkup.meaning meaning

Line 415: Igf_fc_sar_cd_mst sar ,

411: cp_lkup_type VARCHAR2 ) IS
412: SELECT sar.sar_field_number isir_map_col, lkup.meaning meaning
413: FROM igf_ap_batch_aw_map map,
414: igf_ap_fa_base_rec_all fabase,
415: Igf_fc_sar_cd_mst sar ,
416: igf_lookups_view lkup
417: WHERE fabase.base_id = p_base_id
418: AND map.ci_cal_type = fabase.ci_cal_type
419: AND map.ci_sequence_number = fabase.ci_sequence_number