APPS.PVX_MISC_PVT dependencies on HZ_PARTY_SITES

Line 93: FROM HZ_PARTY_SITES

89:
90: -- Cursor : c_party_site
91: CURSOR c_party_site (cv_party_id IN NUMBER) IS
92: SELECT party_site_id
93: FROM HZ_PARTY_SITES
94: WHERE party_id = cv_party_id
95: AND identifying_address_flag = 'Y'
96: AND NVL(start_date_active,SYSDATE) <= SYSDATE
97: AND NVL(end_date_active,SYSDATE) >= SYSDATE;

Line 684: FROM hz_party_sites HZPS

680: ,HZL.state
681: ,HZL.province
682: ,HZL.county
683: ,HZL.country
684: FROM hz_party_sites HZPS
685: ,hz_locations HZL
686: WHERE
687: HZPS.location_id = HZL.location_id(+)
688: AND HZPS.identifying_address_flag(+) = 'Y'