APPS.IGS_FI_GL_INTERFACE dependencies on HZ_PARTIES

Line 351: FUNCTION get_party_number(p_n_party_id hz_parties.party_id%TYPE) RETURN VARCHAR2 AS

347:
348: RETURN l_v_log_line;
349: END get_log_details;
350:
351: FUNCTION get_party_number(p_n_party_id hz_parties.party_id%TYPE) RETURN VARCHAR2 AS
352: /***********************************************************************************************
353:
354: Created By : Amit Gairola
355: Date Created By: 1-Nov-2002

Line 362: CURSOR cur_hzp(cp_party_id hz_parties.party_id%TYPE) IS

358: Change History
359: Who When What
360:
361: ********************************************************************************************** */
362: CURSOR cur_hzp(cp_party_id hz_parties.party_id%TYPE) IS
363: SELECT party_number
364: FROM hz_parties hzp
365: WHERE party_id = cp_party_id;
366:

Line 364: FROM hz_parties hzp

360:
361: ********************************************************************************************** */
362: CURSOR cur_hzp(cp_party_id hz_parties.party_id%TYPE) IS
363: SELECT party_number
364: FROM hz_parties hzp
365: WHERE party_id = cp_party_id;
366:
367: l_v_person_number hz_parties.party_number%TYPE;
368: BEGIN

Line 367: l_v_person_number hz_parties.party_number%TYPE;

363: SELECT party_number
364: FROM hz_parties hzp
365: WHERE party_id = cp_party_id;
366:
367: l_v_person_number hz_parties.party_number%TYPE;
368: BEGIN
369: IF p_n_party_id IS NULL THEN
370: l_v_person_number := NULL;
371: ELSE