APPS.IGF_AP_GEN dependencies on IGF_SL_CL_PREF_LENDERS

Line 780: SELECT clprl_id FROM igf_sl_cl_pref_lenders WHERE

776: --Who When What
777: -------------------------------------------------------------------
778:
779: CURSOR get_active_preflend(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
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

Line 850: p_clprl_id IN igf_sl_cl_pref_lenders.clprl_id%TYPE DEFAULT NULL,

846: PROCEDURE update_td_status(
847: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
848: p_item_sequence_number IN igf_ap_td_item_inst_all.item_sequence_number%TYPE,
849: p_status IN igf_ap_td_item_inst_all.status%TYPE,
850: p_clprl_id IN igf_sl_cl_pref_lenders.clprl_id%TYPE DEFAULT NULL,
851: p_return_status OUT NOCOPY VARCHAR2
852: ) AS
853: ------------------------------------------------------------------
854: --Created by : veramach, Oracle India