APPS.AP_APXINAGE_XMLP_PKG dependencies on HZ_PARTIES

Line 48: L_PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE;

44: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
48: L_PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE;
49: BEGIN
50: BEGIN
51: SELECT displayed_field
52: INTO l_sort_option

Line 103: FROM hz_parties hp

99: BEGIN
100: if (P_PARTY_ID is not null) then
101: SELECT hp.party_name
102: INTO l_party_name
103: FROM hz_parties hp
104: WHERE party_id = P_PARTY_ID;
105: C_VENDOR_NAME_SELECT := L_PARTY_NAME;
106: C_HEAD_VENDOR_NAME := L_PARTY_NAME;
107: P_PARTY_PREDICATE := 'AND HP.party_id = '||P_PARTY_ID;