APPS.JTF_RS_CONC_RES_PUB dependencies on HZ_PARTY_SITES

Line 3394: FROM HZ_PARTY_SITES PARTY_SITE

3390: ,LOC.STATE
3391: ,LOC.PROVINCE
3392: ,LOC.COUNTY
3393: ,LOC.COUNTRY
3394: FROM HZ_PARTY_SITES PARTY_SITE
3395: , HZ_LOCATIONS LOC
3396: WHERE PARTY_SITE.PARTY_SITE_ID = l_address_id
3397: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
3398:

Line 3420: FROM hz_party_sites prt

3416: RES.LAST_UPDATED_BY = l_user_id,
3417: RES.LAST_UPDATE_LOGIN = l_login,
3418: (RES.ADDRESS_ID)
3419: = ( SELECT prt.party_site_id
3420: FROM hz_party_sites prt
3421: WHERE prt.party_id = RES.source_id
3422: AND prt.identifying_address_flag = 'Y'
3423: -- added status flag check 20 nov 2001
3424: AND prt.status = 'A')

Line 3449: FROM hz_party_sites prt

3445: RES.LAST_UPDATED_BY = l_user_id,
3446: RES.LAST_UPDATE_LOGIN = l_login,
3447: (RES.ADDRESS_ID)
3448: = ( SELECT prt.party_site_id
3449: FROM hz_party_sites prt
3450: WHERE prt.party_id = RES.source_id
3451: AND prt.identifying_address_flag = 'Y'
3452: -- added status flag check 20 nov 2001
3453: AND prt.status = 'A')