APPS.IEX_TERR_PUB dependencies on HZ_CUST_ACCOUNTS

Line 321: FROM hz_cust_accounts

317: l_prof_amt_id := p_event.GetValueForParameter('P_CREATE_PROFILE_AMT');
318:
319: BEGIN
320: SELECT party_id INTO l_party_id
321: FROM hz_cust_accounts
322: WHERE cust_account_id = l_custaccount_id;
323: EXCEPTION WHEN OTHERS THEN
324: logmessage('Error while selecting the Party_id' || SQLERRM);
325: END;

Line 899: l_account_name hz_cust_accounts.account_name%type;

895: Type refCur is Ref Cursor;
896: l_curs refCur;
897:
898: l_party_name hz_parties.party_name%type;
899: l_account_name hz_cust_accounts.account_name%type;
900: l_address1 varchar2(240);
901: l_city varchar2(240);
902: l_state varchar2(240);
903: l_county varchar2(240);

Line 936: ' hz_cust_accounts acc, ' ||

932: ' phone.phone_area_code phone_area_code, ' ||
933: ' phone.phone_number phone_number, ' ||
934: ' phone.phone_extension phone_extension ' ||
935: ' FROM ' ||
936: ' hz_cust_accounts acc, ' ||
937: ' hz_parties party, ' ||
938: ' fnd_territories_tl fnd_terr, ' ||
939: ' hz_contact_points phone ' ||
940: ' WHERE ' ||

Line 966: HZ_CUST_ACCOUNTS WHERE

962: l_sql := l_sql || ' AND acc.cust_account_id = :1 '; -- changed for bug 9106462 PNAVEENK
963:
964: BEGIN
965: SELECT PARTY_ID INTO l_party_id from
966: HZ_CUST_ACCOUNTS WHERE
967: CUST_ACCOUNT_ID = p_party_id;
968: EXCEPTION WHEN OTHERS THEN
969: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
970: iex_debug_pub.logmessage ('IEX Summarty Synchronization , Error occurred in party_id select ' || sqlerrm);