APPS.JTF_RS_CONC_RES_PUB dependencies on HZ_PARTY_SITES

Line 3845: FROM HZ_PARTY_SITES PARTY_SITE

3841: ,LOC.STATE
3842: ,LOC.PROVINCE
3843: ,LOC.COUNTY
3844: ,LOC.COUNTRY
3845: FROM HZ_PARTY_SITES PARTY_SITE
3846: , HZ_LOCATIONS LOC
3847: WHERE PARTY_SITE.PARTY_SITE_ID = l_address_id
3848: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
3849:

Line 3871: FROM hz_party_sites prt

3867: RES.LAST_UPDATED_BY = l_user_id,
3868: RES.LAST_UPDATE_LOGIN = l_login,
3869: (RES.ADDRESS_ID)
3870: = ( SELECT prt.party_site_id
3871: FROM hz_party_sites prt
3872: WHERE prt.party_id = RES.source_id
3873: AND prt.identifying_address_flag = 'Y'
3874: -- added status flag check 20 nov 2001
3875: AND prt.status = 'A')

Line 3900: FROM hz_party_sites prt

3896: RES.LAST_UPDATED_BY = l_user_id,
3897: RES.LAST_UPDATE_LOGIN = l_login,
3898: (RES.ADDRESS_ID)
3899: = ( SELECT prt.party_site_id
3900: FROM hz_party_sites prt
3901: WHERE prt.party_id = RES.source_id
3902: AND prt.identifying_address_flag = 'Y'
3903: -- added status flag check 20 nov 2001
3904: AND prt.status = 'A')