APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_COA_GROUP_ALL

Line 1778: FROM igf_aw_coa_group_all coa

1774: CURSOR c_coa_grp_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1775: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1776: ) IS
1777: SELECT coa.*
1778: FROM igf_aw_coa_group_all coa
1779: WHERE coa.ci_cal_type = cp_frm_cal_type
1780: AND coa.ci_sequence_number = cp_frm_sequence_number
1781: ORDER BY coa.coa_code;
1782:

Line 1786: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE

1782:
1783: -- check the existence of the COA Group in the target award year
1784: CURSOR c_coa_grp_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1785: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1786: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1787: ) IS
1788: SELECT 'X' exist
1789: FROM igf_aw_coa_group_all coa
1790: WHERE coa.ci_cal_type = cp_to_cal_type

Line 1789: FROM igf_aw_coa_group_all coa

1785: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1786: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1787: ) IS
1788: SELECT 'X' exist
1789: FROM igf_aw_coa_group_all coa
1790: WHERE coa.ci_cal_type = cp_to_cal_type
1791: AND coa.ci_sequence_number = cp_to_sequence_number
1792: AND coa.coa_code = cp_coa_code;
1793:

Line 1800: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE

1796:
1797: -- Get the COA Items attached to the COA Group
1798: CURSOR c_coa_item( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1799: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1800: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1801: ) IS
1802: SELECT coa_item.*
1803: FROM igf_aw_coa_grp_item_all coa_item
1804: WHERE coa_item.ci_cal_type = cp_frm_cal_type

Line 1830: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE

1826:
1827: -- Get the load percentage split up attached to the COA Group
1828: CURSOR c_ld_coa ( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1829: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1830: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1831: ) IS
1832: SELECT ld_coa.*
1833: FROM igf_aw_coa_ld_all ld_coa
1834: WHERE ld_coa.ci_cal_type = cp_frm_cal_type

Line 1842: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE

1838:
1839: -- Get the overridden items attached to the COA Group
1840: CURSOR c_overridden_item ( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1841: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1842: cp_coa_code igf_aw_coa_group_all.coa_code%TYPE
1843: ) IS
1844: SELECT over.*
1845: FROM igf_aw_cit_ld_ovrd_all over
1846: WHERE over.ci_cal_type = cp_frm_cal_type