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 885: l_account_name hz_cust_accounts.account_name%type;

881: Type refCur is Ref Cursor;
882: l_curs refCur;
883:
884: l_party_name hz_parties.party_name%type;
885: l_account_name hz_cust_accounts.account_name%type;
886: l_address1 varchar2(240);
887: l_city varchar2(240);
888: l_state varchar2(240);
889: l_county varchar2(240);

Line 921: ' hz_cust_accounts acc, ' ||

917: ' phone.phone_area_code phone_area_code, ' ||
918: ' phone.phone_number phone_number, ' ||
919: ' phone.phone_extension phone_extension ' ||
920: ' FROM ' ||
921: ' hz_cust_accounts acc, ' ||
922: ' hz_parties party, ' ||
923: ' fnd_territories_tl fnd_terr, ' ||
924: ' hz_contact_points phone ' ||
925: ' WHERE ' ||

Line 951: HZ_CUST_ACCOUNTS WHERE

947: l_sql := l_sql || ' AND acc.account_id = :1 ';
948:
949: BEGIN
950: SELECT PARTY_ID INTO l_party_id from
951: HZ_CUST_ACCOUNTS WHERE
952: CUST_ACCOUNT_ID = p_party_id;
953: EXCEPTION WHEN OTHERS THEN
954: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
955: iex_debug_pub.logmessage ('IEX Summarty Synchronization , Error occurred in party_id select ' || sqlerrm);