APPS.IGF_AW_GEN_004 dependencies on IGF_AP_TD_ITEM_INST_ALL

Line 1808: l_newcorsp_dt igf_ap_td_item_inst_all.corsp_date%TYPE;

1804: fabase.ci_sequence_number = TO_NUMBER (RTRIM (SUBSTR (p_param1, 11)));
1805:
1806: l_tdrec c_tdcur%ROWTYPE;
1807: l_base igf_ap_fa_base_rec_all.base_id%TYPE;
1808: l_newcorsp_dt igf_ap_td_item_inst_all.corsp_date%TYPE;
1809: l_new_cnt NUMBER;
1810: BEGIN
1811:
1812: -- Get the Baseid for the person in an award year

Line 1979: igf_ap_td_item_inst_all tdii,

1975: CURSOR cur_incomp_items
1976: IS
1977: SELECT tdii.rowid row_id,tdii.*
1978: FROM
1979: igf_ap_td_item_inst_all tdii,
1980: igf_ap_fa_base_rec_all facon
1981: WHERE
1982: facon.base_id = tdii.base_id AND
1983: NVL(tdii.inactive_flag,'N')='N' AND