DBA Data[Home] [Help]

APPS.JTF_RS_CONC_RES_PUB dependencies on HZ_CONTACT_POINTS

Line 3317: HZ_CONTACT_POINTS CT_POINT1

3313: PARTY.PERSON_MIDDLE_NAME MIDDLE_NAME,
3314: PARTY.PERSON_LAST_NAME LAST_NAME
3315: FROM
3316: HZ_PARTIES PARTY,
3317: HZ_CONTACT_POINTS CT_POINT1
3318: WHERE PARTY.PARTY_ID = l_party_id
3319: AND CT_POINT1.OWNER_TABLE_NAME (+)= 'HZ_PARTIES'
3320: AND CT_POINT1.OWNER_TABLE_ID (+)= PARTY.PARTY_ID
3321: AND CT_POINT1.PRIMARY_FLAG (+)= 'Y'

Line 3342: HZ_CONTACT_POINTS CT_POINT1,

3338: FROM
3339: HZ_PARTIES PARTY,
3340: HZ_PARTIES PARTY2,
3341: HZ_PARTIES PARTY3,
3342: HZ_CONTACT_POINTS CT_POINT1,
3343: HZ_RELATIONSHIPS REL
3344: WHERE PARTY.PARTY_ID = l_party_id
3345: AND (
3346: (