APPS.IGS_FI_PRC_APINT dependencies on IGS_PE_ALT_PERS_ID

Line 748: -- cursor for fetching the alternate person id from igs_pe_alt_pers_id

744: || Who When What
745: || (reverse chronological order - newest change first)
746: ******************************************************************/
747:
748: -- cursor for fetching the alternate person id from igs_pe_alt_pers_id
749: CURSOR c_api_pers(cp_n_party_id hz_parties.party_id%TYPE,
750: cp_v_pers_id_type igs_pe_alt_pers_id.person_id_type%TYPE) IS
751: SELECT api_person_id
752: FROM igs_pe_alt_pers_id

Line 750: cp_v_pers_id_type igs_pe_alt_pers_id.person_id_type%TYPE) IS

746: ******************************************************************/
747:
748: -- cursor for fetching the alternate person id from igs_pe_alt_pers_id
749: CURSOR c_api_pers(cp_n_party_id hz_parties.party_id%TYPE,
750: cp_v_pers_id_type igs_pe_alt_pers_id.person_id_type%TYPE) IS
751: SELECT api_person_id
752: FROM igs_pe_alt_pers_id
753: WHERE pe_person_id = cp_n_party_id
754: AND person_id_type = g_v_sup_num

Line 752: FROM igs_pe_alt_pers_id

748: -- cursor for fetching the alternate person id from igs_pe_alt_pers_id
749: CURSOR c_api_pers(cp_n_party_id hz_parties.party_id%TYPE,
750: cp_v_pers_id_type igs_pe_alt_pers_id.person_id_type%TYPE) IS
751: SELECT api_person_id
752: FROM igs_pe_alt_pers_id
753: WHERE pe_person_id = cp_n_party_id
754: AND person_id_type = g_v_sup_num
755: AND sysdate BETWEEN start_dt AND NVL(end_dt,sysdate);
756:

Line 758: l_v_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;

754: AND person_id_type = g_v_sup_num
755: AND sysdate BETWEEN start_dt AND NVL(end_dt,sysdate);
756:
757: l_v_sup_num po_vendors.segment1%TYPE;
758: l_v_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
759:
760: BEGIN
761: p_b_status := TRUE;
762: