APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_TARGET_GRP_ALL

Line 2353: FROM igf_aw_target_grp_all grp

2349: CURSOR c_award_grp_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2350: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
2351: ) IS
2352: SELECT grp.*
2353: FROM igf_aw_target_grp_all grp
2354: WHERE grp.cal_type = cp_frm_cal_type
2355: AND grp.sequence_number = cp_frm_sequence_number
2356: ORDER BY grp.group_cd;
2357:

Line 2362: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE

2358:
2359: -- Check whether the award group already got rolled over or not
2360: CURSOR c_grp_exists (cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2361: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2362: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE
2363: ) IS
2364: SELECT 'X' exist
2365: FROM igf_aw_target_grp_all grp
2366: WHERE grp.cal_type = cp_to_cal_type

Line 2365: FROM igf_aw_target_grp_all grp

2361: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2362: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE
2363: ) IS
2364: SELECT 'X' exist
2365: FROM igf_aw_target_grp_all grp
2366: WHERE grp.cal_type = cp_to_cal_type
2367: AND grp.sequence_number = cp_to_sequence_number
2368: AND grp.group_cd = cp_group_cd;
2369:

Line 2376: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE

2372:
2373: -- Get the sequence of funds attached to the formulas for the source award year
2374: CURSOR c_formula_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2375: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2376: cp_group_cd igf_aw_target_grp_all.group_cd%TYPE
2377: ) IS
2378: SELECT frm.*
2379: FROM igf_aw_awd_frml_det_all frm
2380: WHERE frm.ci_cal_type = cp_frm_cal_type

Line 2433: l_tgrp_id igf_aw_target_grp_all.tgrp_id%TYPE;

2429:
2430: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
2431: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2432: l_rowid VARCHAR2(25):= NULL;
2433: l_tgrp_id igf_aw_target_grp_all.tgrp_id%TYPE;
2434: E_SKIP_AWARD_GRP EXCEPTION;
2435: l_error_occurred VARCHAR2(1) := 'N';
2436: l_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;
2437: