APPS.INL_INTERFACE_PVT dependencies on HZ_PARTIES

Line 589: FROM hz_parties

585: p_debug_info => l_debug_info
586: ) ;
587: SELECT party_id
588: INTO l_return_value
589: FROM hz_parties
590: WHERE PARTY_NUMBER = p_party_number;
591: -- Standard End of Procedure/Function Logging
592: INL_LOGGING_PVT.Log_EndProc(
593: p_module_name => g_module_name,

Line 1372: FROM hz_parties

1368: l_column_value := x_party_NUMBER;
1369:
1370: SELECT party_id
1371: INTO x_party_id
1372: FROM hz_parties
1373: WHERE party_number = x_party_number;
1374: END IF;
1375:
1376: ELSIF p_validation_flag = 'Y' THEN

Line 1407: hz_parties hp1

1403: COUNT(1)
1404: FROM
1405: hz_party_usages_vl pu,
1406: hz_party_usg_assignments ua,
1407: hz_parties hp1
1408: WHERE
1409: pu.party_usage_code = ua.party_usage_code
1410: AND ua.party_id = hp1.party_id
1411: AND UPPER(pu.party_usage_code)

Line 1426: FROM hz_parties hp

1422: x_party_id,
1423: x_party_number,
1424: l_count_alw_party_type,
1425: l_count_alw_party_usg
1426: FROM hz_parties hp
1427: WHERE
1428: (x_party_id IS NOT NULL
1429: AND party_id = x_party_id)
1430: OR party_number = x_party_number;

Line 13867: l_debug_info := 'Chech Party_Id in HZ_PARTIES table';

13863:
13864: l_debug_info := 'party_id: ';
13865: IF p_party_id IS NOT NULL THEN
13866: BEGIN
13867: l_debug_info := 'Chech Party_Id in HZ_PARTIES table';
13868: INL_LOGGING_PVT.Log_Statement(
13869: p_module_name => g_module_name,
13870: p_procedure_name => l_program_name,
13871: p_debug_info => l_debug_info

Line 13875: FROM hz_parties

13871: p_debug_info => l_debug_info
13872: );
13873: SELECT 'x'
13874: INTO l_field
13875: FROM hz_parties
13876: WHERE p_party_id = party_id;
13877:
13878: l_debug_info := l_debug_info||'(OK) ';
13879: EXCEPTION