APPS.IGS_CO_PROCESS dependencies on IGS_FI_ENCMB_TYPE

Line 828: FROM igs_pe_pers_encumb ppe, igs_pe_persenc_effct ppef,igs_pe_person_base_v ppbv,igs_fi_encmb_type fet

824: l_hold_count NUMBER;
825:
826: CURSOR log_details IS
827: SELECT ppbv.full_name,ppbv.person_number,fet.description
828: FROM igs_pe_pers_encumb ppe, igs_pe_persenc_effct ppef,igs_pe_person_base_v ppbv,igs_fi_encmb_type fet
829: WHERE ppe.person_id = p_person_id
830: AND ppe.person_id = ppef.person_id
831: AND ppe.person_id = ppbv.person_id
832: AND ppe.encumbrance_type = ppef.encumbrance_type

Line 843: l_encumbrance_desc igs_fi_encmb_type.description%TYPE;

839: AND (ppe.expiry_dt IS NULL OR trunc(ppe.expiry_dt) > trunc(sysdate));
840:
841: l_full_name igs_pe_person_base_v.full_name%TYPE;
842: l_person_number igs_pe_person_base_v.person_number%TYPE;
843: l_encumbrance_desc igs_fi_encmb_type.description%TYPE;
844:
845: l_query_id jtf_fm_query_mes.query_id%TYPE;
846: l_content_type VARCHAR2(10);
847: l_tmp_var VARCHAR2(4000);