APPS.INL_INTERFACE_PVT dependencies on HZ_PARTY_SITES

Line 668: FROM hz_party_sites

664: p_debug_info => l_debug_info
665: ) ;
666: SELECT party_site_id
667: INTO l_return_value
668: FROM hz_party_sites
669: WHERE party_site_number = p_party_site_number;
670: -- Standard End of Procedure/Function Logging
671: INL_LOGGING_PVT.Log_EndProc(
672: p_module_name => g_module_name,

Line 1629: FROM hz_party_sites hps

1625: l_column_value := x_party_site_number;
1626:
1627: SELECT hps.party_site_id
1628: INTO x_party_site_id
1629: FROM hz_party_sites hps
1630: WHERE party_site_number = x_party_site_number;
1631: END IF;
1632: ELSE
1633:

Line 1657: FROM hz_party_sites hps1

1653:
1654: SELECT hps.party_site_id,
1655: hps.party_site_number,
1656: (SELECT COUNT(1)
1657: FROM hz_party_sites hps1
1658: WHERE hps1.party_id = p_party_id
1659: AND hps1.party_site_id = hps.party_site_id),
1660: (SELECT COUNT(1)
1661: FROM hz_party_sites hps2,

Line 1661: FROM hz_party_sites hps2,

1657: FROM hz_party_sites hps1
1658: WHERE hps1.party_id = p_party_id
1659: AND hps1.party_site_id = hps.party_site_id),
1660: (SELECT COUNT(1)
1661: FROM hz_party_sites hps2,
1662: hz_locations hl,
1663: fnd_territories_vl ftv,
1664: inl_ship_types_vl shv
1665: WHERE hps.location_id = hl.location_id

Line 1678: FROM hz_party_sites hps

1674: x_party_site_id,
1675: x_party_site_number,
1676: l_count_belongs_party,
1677: l_count_alw_party
1678: FROM hz_party_sites hps
1679: WHERE ( x_party_site_id IS NOT null
1680: AND party_site_id = x_party_site_id)
1681: OR party_site_number = x_party_site_number;
1682:

Line 13905: FROM hz_party_sites

13901: IF p_party_site_id IS NOT NULL THEN
13902: BEGIN
13903: SELECT 'x'
13904: INTO l_field
13905: FROM hz_party_sites
13906: WHERE party_site_id = p_party_site_id;
13907:
13908: l_debug_info := l_debug_info||'(OK) ';
13909: EXCEPTION