DBA Data[Home] [Help]

APPS.FUN_WF_COMMON dependencies on HZ_ORG_CONTACT_ROLES

Line 1185: hz_org_contact_roles hcr

1181: fnd_user fu,
1182: fun_trx_headers ftrx,
1183: hz_relationships hzr,
1184: hz_org_contacts hc,
1185: hz_org_contact_roles hcr
1186: WHERE p.party_type = 'PERSON'
1187: AND p.party_id = hzr.subject_id
1188: AND hzr.object_id = ftrx.recipient_id
1189: AND hzr.relationship_code = 'CONTACT_OF'

Line 1210: hz_org_contact_roles cr

1206: FROM fun_trx_headers trx,
1207: hz_relationships rel,
1208: fnd_user wf,
1209: hz_org_contacts c,
1210: hz_org_contact_roles cr
1211: WHERE wf.user_name = p_role_name
1212: AND wf.person_party_id = rel.subject_id
1213: AND trx.trx_id = p_transaction_id
1214: AND rel.object_id = DECODE(p_org_type, 'R',trx.recipient_id,