APPS.IGF_AP_PROFILE_GEN_PKG dependencies on IGF_AP_BATCH_AW_MAP

Line 58: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS

54: || ridas 14-Feb-2006 Bug #5021084. Removed trunc function from cursor C_SSN.
55: */
56:
57: -- Cursor to get cal_type and sequence_number from batch_year
58: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
59: SELECT ibm.ci_cal_type, ibm.ci_sequence_number
60: FROM IGF_AP_BATCH_AW_MAP ibm
61: WHERE ibm.batch_year = cp_batch_year;
62:

Line 60: FROM IGF_AP_BATCH_AW_MAP ibm

56:
57: -- Cursor to get cal_type and sequence_number from batch_year
58: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
59: SELECT ibm.ci_cal_type, ibm.ci_sequence_number
60: FROM IGF_AP_BATCH_AW_MAP ibm
61: WHERE ibm.batch_year = cp_batch_year;
62:
63: rec_get_cal_sequence cur_get_cal_sequence%ROWTYPE;
64:

Line 65: lv_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;

61: WHERE ibm.batch_year = cp_batch_year;
62:
63: rec_get_cal_sequence cur_get_cal_sequence%ROWTYPE;
64:
65: lv_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
66: lv_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;
67: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
68: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE;
69:

Line 66: lv_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;

62:
63: rec_get_cal_sequence cur_get_cal_sequence%ROWTYPE;
64:
65: lv_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
66: lv_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;
67: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
68: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE;
69:
70: lv_profile_value VARCHAR2(10);