APPS.ECX_TP_API dependencies on ECX_HUB_USERS

Line 538: from ecx_hub_users

534: Begin
535: if(x_hub_user_id is not null) then
536: select username,password
537: into x_username,x_password
538: from ecx_hub_users
539: where hub_user_id=x_hub_user_id ;
540: end if;
541: Exception
542: When no_data_found then

Line 772: l_hub_user_id ecx_hub_users.hub_user_id%type;

768: )IS
769:
770: l_confirmation ecx_tp_details.confirmation%type;
771: l_connection_type ecx_tp_details.connection_type%type;
772: l_hub_user_id ecx_hub_users.hub_user_id%type;
773: l_source_tp_location_code ecx_tp_details.source_tp_location_code%type;
774:
775: cursor get_src_loc_code (i_hub_id IN pls_integer) is
776: select name

Line 782: from ecx_hub_users

778: where hub_id = i_hub_id;
779:
780: cursor get_hub_entity_code is
781: select hub_entity_code
782: from ecx_hub_users
783: where hub_user_id = p_hub_user_id;
784:
785: Cursor c1 Is
786: select 1 from ecx_tp_headers

Line 798: select 1 from ecx_hub_users

794: select map_id from ecx_mappings
795: where map_code = p_map_code;
796:
797: Cursor c4 Is
798: select 1 from ecx_hub_users
799: where hub_user_id = p_hub_user_id;
800:
801: Cursor c5 Is
802: select 1 from ecx_tp_details

Line 1454: from ecx_hub_users

1450: where hub_id = i_hub_id;
1451:
1452: cursor get_hub_entity_code is
1453: select hub_entity_code
1454: from ecx_hub_users
1455: where hub_user_id = p_hub_user_id;
1456:
1457: cursor c1 is
1458: select map_id from ecx_mappings

Line 1470: select 1 from ecx_hub_users

1466: select 1 from ecx_tp_details
1467: where tp_detail_id = p_tp_detail_id;
1468:
1469: Cursor c4 Is
1470: select 1 from ecx_hub_users
1471: where hub_user_id = p_hub_user_id;
1472:
1473: Cursor c5 Is
1474: select 1 from ecx_tp_details