APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_FUND_UNIT_ALL

Line 264: p_pay_unit OUT NOCOPY igf_aw_fund_unit_all.unit_cd%TYPE

260:
261: --Create pay units for the target award year
262: FUNCTION create_pay_unit (p_ref_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
263: p_new_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
264: p_pay_unit OUT NOCOPY igf_aw_fund_unit_all.unit_cd%TYPE
265: )
266: RETURN BOOLEAN IS
267: --------------------------------------------------------------------------------
268: -- Created by : ridas, Oracle India

Line 280: FROM igf_aw_fund_unit_all unt

276: -- Get the details of the pay units for a given Fund ID
277: CURSOR c_get_units ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
278: ) IS
279: SELECT unt.unit_cd
280: FROM igf_aw_fund_unit_all unt
281: WHERE fund_id = cp_ref_fund_id;
282:
283: -- Cursor to fetch all the existing versions for the UNIT
284: CURSOR c_get_unit_ver ( cp_unit_code igs_ps_unit_ver_all.unit_cd%TYPE

Line 292: l_funit_id igf_aw_fund_unit_all.funit_id%TYPE;

288: WHERE unit_cd = cp_unit_code
289: ORDER BY version_number asc;
290:
291: l_rowid VARCHAR2(25);
292: l_funit_id igf_aw_fund_unit_all.funit_id%TYPE;
293:
294: BEGIN
295: FOR l_get_units IN c_get_units( p_ref_fund_id ) LOOP
296: FOR l_get_unit_ver IN c_get_unit_ver (l_get_units.unit_cd)

Line 771: l_pay_unit igf_aw_fund_unit_all.unit_cd%TYPE;

767:
768: l_new_fund_id igf_aw_fund_mast_all.fund_id%TYPE := NULL;
769: E_SKIP_FUND EXCEPTION;
770: l_pay_program igf_aw_fund_prg_all.course_cd%TYPE;
771: l_pay_unit igf_aw_fund_unit_all.unit_cd%TYPE;
772: l_fee_class igf_aw_fund_feeclas_all.fee_class%TYPE;
773: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE;
774: l_inclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;
775: l_exclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;