APPS.AMS_REGISTRANTS_PVT dependencies on HZ_LOCATIONS

Line 1868: hz_locations loc,

1864:
1865: cursor c_address_country is
1866: select max(psite.party_id)
1867: from hz_party_sites psite,
1868: hz_locations loc,
1869: hz_parties party
1870: where psite.location_id = loc.location_id
1871: and loc.address1 = p_address1
1872: and loc.country = p_country

Line 1983: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,

1979: x_per_party_id number;
1980: L_API_NAME CONSTANT VARCHAR2(30) := ' party_echeck';
1981:
1982: cursor c_address_country is
1983: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
1984: hz_parties party
1985: where psite.location_id = loc.location_id
1986: and loc.address1 = p_address1
1987: and loc.country = p_country

Line 1992: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,

1988: and party.customer_key = l_party_key
1989: and psite.party_id = party.party_id;
1990:
1991: cursor c_country is
1992: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
1993: hz_parties party
1994: where psite.location_id = loc.location_id
1995: and loc.country = p_country
1996: and party.customer_key = l_party_key

Line 2315: from hz_party_sites ps, hz_locations loc

2311:
2312:
2313: cursor c_addr_ps is
2314: select max(loc.location_id)
2315: from hz_party_sites ps, hz_locations loc
2316: where ps.party_id = p_party_id
2317: and ps.location_id = loc.location_id
2318: and loc.address_key = l_address_key
2319: and loc.country = p_country

Line 2324: from hz_locations loc

2320: and nvl(loc.city,p_city) = p_city;
2321:
2322: cursor c_addr is
2323: select max(loc.location_id)
2324: from hz_locations loc
2325: where loc.address_key = l_address_key
2326: and loc.country = p_country
2327: and nvl(loc.city,p_city) = p_city;
2328: