APPS.IGF_SP_ASSIGN_PUB dependencies on IGS_PE_ALT_PERS_ID

Line 54: p_c_api_prsn_id IN igs_pe_alt_pers_id.api_person_id%TYPE,

50: END validate_prsn;
51:
52: PROCEDURE validate_api_prsn_id(p_c_sys_prsn_id_typ IN igs_pe_person_id_typ.s_person_id_type%TYPE,
53: p_c_usr_alt_prsn_id_typ IN igs_pe_person_id_typ.person_id_type%TYPE,
54: p_c_api_prsn_id IN igs_pe_alt_pers_id.api_person_id%TYPE,
55: p_b_ret_status OUT NOCOPY BOOLEAN,
56: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE)
57: AS
58: /****************************************************************************

Line 71: cp_c_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE)

67: ******************************************************************************/
68:
69: CURSOR cur_get_person_id(cp_c_sys_prsn_id_typ igs_pe_person_id_typ.s_person_id_type%TYPE,
70: cp_c_usr_alt_prs_id_type igs_pe_person_id_typ.person_id_type%TYPE,
71: cp_c_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE)
72: IS
73: SELECT api.pe_person_id
74: FROM igs_pe_person_id_typ pit,
75: igs_pe_alt_pers_id api

Line 75: igs_pe_alt_pers_id api

71: cp_c_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE)
72: IS
73: SELECT api.pe_person_id
74: FROM igs_pe_person_id_typ pit,
75: igs_pe_alt_pers_id api
76: WHERE api.person_id_type = pit.person_id_type AND
77: api.person_id_type = cp_c_usr_alt_prs_id_type AND
78: api.api_person_id = cp_c_api_person_id AND
79: pit.s_person_id_type = cp_c_sys_prsn_id_typ AND