DBA Data[Home] [Help]

APPS.IGF_GR_GEN dependencies on IGF_AW_CIT_LD_OVERIDE

Line 1581: igf_aw_cit_ld_overide

1577: IS
1578: SELECT
1579: row_id
1580: FROM
1581: igf_aw_cit_ld_overide
1582: WHERE
1583: coa_code = p_coa_code AND
1584: ci_cal_type = p_cal_type AND
1585: ci_sequence_number = p_sequence_number AND

Line 1762: igf_aw_cit_ld_overide

1758: IS
1759: SELECT
1760: ld_perct
1761: FROM
1762: igf_aw_cit_ld_overide
1763: WHERE
1764: coa_code = p_coa_code AND
1765: ci_cal_type = p_cal_type AND
1766: ci_sequence_number = p_sequence_number AND

Line 1784: igf_aw_cit_ld_overide

1780: IS
1781: SELECT
1782: SUM(ld_perct)
1783: FROM
1784: igf_aw_cit_ld_overide
1785: WHERE
1786: coa_code = p_coa_code AND
1787: ci_cal_type = p_cal_type AND
1788: ci_sequence_number = p_sequence_number AND

Line 1805: TYPE ovd_list IS TABLE OF igf_aw_cit_ld_overide.ld_perct%TYPE

1801: --
1802: -- PL/SQL table to store Overidden load %
1803: --
1804:
1805: TYPE ovd_list IS TABLE OF igf_aw_cit_ld_overide.ld_perct%TYPE
1806: INDEX BY BINARY_INTEGER;
1807: ovd_ele ovd_list;
1808:
1809: ln_count_i BINARY_INTEGER;

Line 2021: igf_aw_cit_ld_overide

2017: IS
2018: SELECT
2019: ld_perct
2020: FROM
2021: igf_aw_cit_ld_overide
2022: WHERE
2023: coa_code = p_coa_code AND
2024: ci_cal_type = p_cal_type AND
2025: ci_sequence_number = p_sequence_number;

Line 2201: igf_aw_cit_ld_overide

2197: IS
2198: SELECT
2199: cldo_id
2200: FROM
2201: igf_aw_cit_ld_overide
2202: WHERE
2203: coa_code = p_coa_code AND
2204: ci_cal_type = p_cal_type AND
2205: ci_sequence_number = p_sequence_number AND

Line 2292: igf_aw_cit_ld_overide

2288: IS
2289: SELECT
2290: DISTINCT item_code
2291: FROM
2292: igf_aw_cit_ld_overide
2293: WHERE
2294: coa_code = p_coa_code AND
2295: ci_cal_type = p_cal_type AND
2296: ci_sequence_number = p_sequence_number;