APPS.IGS_CO_PROCESS dependencies on IGS_PE_PERSON_BASE_V

Line 598: FROM igs_pe_person_base_v

594:
595: --**
596: CURSOR cur_get_per_num(cp_person_id NUMBER) IS
597: SELECT person_number
598: FROM igs_pe_person_base_v
599: WHERE person_id = TO_NUMBER(cp_person_id);
600: l_cur_get_per_num cur_get_per_num%ROWTYPE;
601:
602: l_count NUMBER(16);

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 841: l_full_name igs_pe_person_base_v.full_name%TYPE;

837: AND (ppef.expiry_dt IS NULL OR trunc(ppef.expiry_dt) > trunc(sysdate))
838: AND trunc(ppe.start_dt) <= trunc(sysdate)
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;

Line 842: l_person_number igs_pe_person_base_v.person_number%TYPE;

838: AND trunc(ppe.start_dt) <= trunc(sysdate)
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);

Line 864: FROM igs_pe_person_base_v

860:
861: -- Cursor to log the person's processed
862: CURSOR c_per_processed (p_person_id NUMBER) IS
863: SELECT person_number,full_name
864: FROM igs_pe_person_base_v
865: WHERe person_id = p_person_id;
866:
867: --Cursor to get the citem_version_id
868: CURSOR c_check_relation (cp_item_id ibc_citem_versions_b.content_item_id%TYPE,