eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_PE_PERSON_ID_TYP

Line 842: p_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE,

838: RETURN l_v_sys_fund_type;
839: END get_sys_fund_type;
840:
841: PROCEDURE get_alt_person_id(p_n_person_id igs_pe_person_base_v.person_id%TYPE,
842: p_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE,
843: p_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE,
844: p_v_api_pers_id OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,
845: p_v_api_pers_id_uf OUT NOCOPY igs_pe_alt_pers_id.api_person_id_uf%TYPE) AS
846:

Line 843: p_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE,

839: END get_sys_fund_type;
840:
841: PROCEDURE get_alt_person_id(p_n_person_id igs_pe_person_base_v.person_id%TYPE,
842: p_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE,
843: p_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE,
844: p_v_api_pers_id OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,
845: p_v_api_pers_id_uf OUT NOCOPY igs_pe_alt_pers_id.api_person_id_uf%TYPE) AS
846:
847: /******************************************************************

Line 857: cp_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS

853: Change History
854: Who When What
855: ***************************************************************** */
856: CURSOR cur_api_pid1(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
857: cp_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
858: SELECT altid.api_person_id,
859: altid.api_person_id_uf
860: FROM igs_pe_alt_pers_id altid,
861: igs_pe_person_id_typ pid

Line 861: igs_pe_person_id_typ pid

857: cp_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
858: SELECT altid.api_person_id,
859: altid.api_person_id_uf
860: FROM igs_pe_alt_pers_id altid,
861: igs_pe_person_id_typ pid
862: WHERE altid.pe_person_id = cp_n_person_id
863: AND altid.person_id_type = pid.person_id_type
864: AND pid.s_person_id_type = cp_v_s_person_id_type
865: AND sysdate BETWEEN altid.start_dt AND NVL(altid.end_dt, sysdate)

Line 869: cp_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE,

865: AND sysdate BETWEEN altid.start_dt AND NVL(altid.end_dt, sysdate)
866: AND pid.closed_ind = 'N';
867:
868: CURSOR cur_api_pid2(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
869: cp_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE,
870: cp_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
871: SELECT altid.api_person_id,
872: altid.api_person_id_uf
873: FROM igs_pe_alt_pers_id altid,

Line 870: cp_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS

866: AND pid.closed_ind = 'N';
867:
868: CURSOR cur_api_pid2(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
869: cp_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE,
870: cp_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
871: SELECT altid.api_person_id,
872: altid.api_person_id_uf
873: FROM igs_pe_alt_pers_id altid,
874: igs_pe_person_id_typ pid

Line 874: igs_pe_person_id_typ pid

870: cp_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
871: SELECT altid.api_person_id,
872: altid.api_person_id_uf
873: FROM igs_pe_alt_pers_id altid,
874: igs_pe_person_id_typ pid
875: WHERE altid.pe_person_id = cp_n_person_id
876: AND altid.person_id_type = pid.person_id_type
877: AND pid.s_person_id_type = cp_v_s_person_id_type
878: AND altid.person_id_type = cp_v_person_id_type