DBA Data[Home] [Help]

APPS.JTF_RS_CONC_RES_PUB dependencies on HZ_CONTACT_POINTS

Line 3768: HZ_CONTACT_POINTS CT_POINT1

3764: PARTY.PERSON_MIDDLE_NAME MIDDLE_NAME,
3765: PARTY.PERSON_LAST_NAME LAST_NAME
3766: FROM
3767: HZ_PARTIES PARTY,
3768: HZ_CONTACT_POINTS CT_POINT1
3769: WHERE PARTY.PARTY_ID = l_party_id
3770: AND CT_POINT1.OWNER_TABLE_NAME (+)= 'HZ_PARTIES'
3771: AND CT_POINT1.OWNER_TABLE_ID (+)= PARTY.PARTY_ID
3772: AND CT_POINT1.PRIMARY_FLAG (+)= 'Y'

Line 3793: HZ_CONTACT_POINTS CT_POINT1,

3789: FROM
3790: HZ_PARTIES PARTY,
3791: HZ_PARTIES PARTY2,
3792: HZ_PARTIES PARTY3,
3793: HZ_CONTACT_POINTS CT_POINT1,
3794: HZ_RELATIONSHIPS REL
3795: WHERE PARTY.PARTY_ID = l_party_id
3796: AND (
3797: (