DBA Data[Home] [Help]

APPS.FUN_WF_COMMON dependencies on HZ_ORG_CONTACTS

Line 990: hz_org_contacts hc,

986: FROM hz_parties p,
987: fnd_user fu,
988: fun_trx_headers ftrx,
989: hz_relationships hzr,
990: hz_org_contacts hc,
991: hz_org_contact_roles hcr
992: WHERE p.party_type = 'PERSON'
993: AND p.party_id = hzr.subject_id
994: AND hzr.object_id = ftrx.recipient_id

Line 1015: hz_org_contacts c,

1011: SELECT 'X'
1012: FROM fun_trx_headers trx,
1013: hz_relationships rel,
1014: fnd_user wf,
1015: hz_org_contacts c,
1016: hz_org_contact_roles cr
1017: WHERE wf.user_name = p_role_name
1018: AND wf.person_party_id = rel.subject_id
1019: AND trx.trx_id = p_transaction_id