DBA Data[Home] [Help]

APPS.OKS_CT_EVENTS_WFA dependencies on OKC_K_PARTY_ROLES_V

Line 345: and object_id = (select object1_id1 from okc_k_party_roles_v

341: chcpv.party_type party_type
342: from csc_hz_parties_v chpv,
343: csc_hz_contact_points_v chcpv
344: where obj_party_type = 'ORGANIZATION'
345: and object_id = (select object1_id1 from okc_k_party_roles_v
346: where jtot_object1_code = 'OKX_PARTY'
347: and chr_id = (select chr_id from okc_k_lines_v where id = l_k_line_id)
348: and rownum = 1) --l_party_id
349: and chpv.party_id = chcpv.party_id --and chpv.subject_id = chcpv.party_id

Line 366: and chpv.object_id = (select object1_id1 from okc_k_party_roles_v

362: from csc_hz_parties_v chpv,
363: csc_hz_contact_points_v chcpv,
364: hz_relationships r
365: where chpv.obj_party_type = 'ORGANIZATION'
366: and chpv.object_id = (select object1_id1 from okc_k_party_roles_v
367: where jtot_object1_code = 'OKX_PARTY'
368: and chr_id = (select chr_id from okc_k_lines_v where
369: id = l_k_line_id)
370: and rownum = 1)