APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on HZ_PARTY_SITES

Line 108: , hz_party_sites hzps

104: --Cursor to validate party based on party number : Single Row
105: CURSOR c_validate_party(l_party_number VARCHAR2, l_party_site_id NUMBER) IS
106: SELECT hzp.party_id
107: FROM hz_parties hzp
108: , hz_party_sites hzps
109: WHERE hzp.party_number = l_party_number
110: AND hzp.party_id = hzps.party_id
111: and hzps.party_site_id = l_party_site_id
112: AND hzp.status = 'A';

Line 463: HZ_PARTY_SITES H2

459: l_trade_name,
460: l_postal_code
461: FROM HZ_PARTIES H3,
462: HZ_LOCATIONS H1,
463: HZ_PARTY_SITES H2
464: WHERE h3.party_id = h2.party_id
465: AND h2.location_id = h1.location_id
466: AND h3.party_id = p_party_id
467: AND h2.party_site_id = p_party_site_id;

Line 618: , hz_party_sites hzps

614: CURSOR c_validate_party(l_party_number VARCHAR2, l_party_site_id NUMBER) IS
615:
616: SELECT hzp.party_id, hzp.duns_number_c
617: FROM hz_parties hzp
618: , hz_party_sites hzps
619: WHERE hzp.party_number = l_party_number
620: AND hzp.party_id = hzps.party_id
621: and hzps.party_site_id = l_party_site_id
622: AND hzp.status = 'A';

Line 3364: from hz_party_sites party_site, hz_parties party

3360: elsif ((p_party_site_id is null or trim(p_party_site_id) is null ) and (trim(l_matching_rule_code) <> '1' or trim(l_matching_rule_code) <> '2' or trim(l_matching_rule_code) <> '5'))
3361: then
3362:
3363: select party_site_id into l_party_site_id
3364: from hz_party_sites party_site, hz_parties party
3365: where party.party_number = p_party_number
3366: and party.party_id = party_site.party_id
3367: and party_site.status = 'A'
3368: and party_site.identifying_address_flag = 'Y';

Line 3373: FROM hz_party_sites

3369:
3370: else
3371: SELECT PARTY_SITE_ID
3372: INTO l_party_site_id
3373: FROM hz_party_sites
3374: WHERE party_site_number = P_PARTY_SITE_ID;
3375: end if;
3376:
3377:

Line 3438: FROM hz_party_sites

3434: ELSE
3435:
3436: SELECT PARTY_SITE_ID
3437: INTO l_party_site_id
3438: FROM hz_party_sites
3439: WHERE party_site_number = P_PARTY_SITE_ID;
3440:
3441:
3442: END IF;