APPS.IGF_AP_GEN dependencies on IGF_AP_TD_ITEM_INST_V

Line 784: SELECT clprl_id,base_id,item_sequence_number,status FROM igf_ap_td_item_inst_v WHERE

780: SELECT clprl_id FROM igf_sl_cl_pref_lenders WHERE
781: person_id = cp_person_id AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date,TRUNC(SYSDATE));
782:
783: CURSOR preflend_todo_item_dtls (cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
784: SELECT clprl_id,base_id,item_sequence_number,status FROM igf_ap_td_item_inst_v WHERE
785: person_id = cp_person_id AND system_todo_type_code='PREFLEND';
786:
787: preflend_todo_item_rec preflend_todo_item_dtls%ROWTYPE;
788: l_status VARCHAR2(10);