APPS.IGF_DB_SF_INTEGRATION dependencies on IGF_AP_FA_BASE_REC_ALL

Line 1443: CURSOR cur_base(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

1439: FROM igf_aw_fund_mast
1440: WHERE fund_id = p_fund_id;
1441: l_cur_fund cur_fund%ROWTYPE;
1442:
1443: CURSOR cur_base(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1444: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1445: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE)
1446: IS
1447: SELECT base_id

Line 1444: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

1440: WHERE fund_id = p_fund_id;
1441: l_cur_fund cur_fund%ROWTYPE;
1442:
1443: CURSOR cur_base(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1444: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1445: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE)
1446: IS
1447: SELECT base_id
1448: FROM igf_ap_fa_base_rec

Line 1445: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE)

1441: l_cur_fund cur_fund%ROWTYPE;
1442:
1443: CURSOR cur_base(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1444: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1445: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE)
1446: IS
1447: SELECT base_id
1448: FROM igf_ap_fa_base_rec
1449: WHERE person_id = cp_person_id

Line 1482: lv_person_id igf_ap_fa_base_rec_all.person_id%TYPE;

1478: l_v_curr_desc fnd_currencies_tl.name%TYPE;
1479: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
1480: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
1481: lv_profile_value VARCHAR2(30);
1482: lv_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
1483: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1484:
1485: BEGIN
1486: