APPS.IGF_SL_CL_CHG_FILE dependencies on HZ_PARTIES

Line 77: RETURN hz_parties.party_number%TYPE;

73: )
74: RETURN igf_ap_fa_base_rec_all.base_id%TYPE;
75:
76: FUNCTION get_person_number (p_n_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE)
77: RETURN hz_parties.party_number%TYPE;
78:
79: FUNCTION validate_cl_lar (p_rec_lorlar lorlar_recTyp) RETURN BOOLEAN;
80:
81: PROCEDURE proc_update_loan_rec(p_loan_rec igf_sl_loans%ROWTYPE);

Line 777: RETURN hz_parties.party_number%TYPE AS

773: RETURN l_n_base_id;
774: END get_base_id;
775:
776: FUNCTION get_person_number (p_n_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE)
777: RETURN hz_parties.party_number%TYPE AS
778: ------------------------------------------------------------------
779: --Created by : Sanil Madathil, Oracle IDC
780: --Date created: 25 October 2004
781: --

Line 800: l_v_person_number hz_parties.party_number%TYPE;

796: SELECT person_number
797: FROM igs_pe_person_base_v
798: WHERE person_id = cp_n_person_id;
799:
800: l_v_person_number hz_parties.party_number%TYPE;
801: BEGIN
802: log_to_fnd(p_v_module => 'get_person_number',
803: p_v_string =>' Entered Procedure get_person_number: The input parameters are ' ||
804: ' p_n_person_id : ' ||p_n_person_id