DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on CSI_II_RELATIONSHIPS

Line 8216: from CSI_II_RELATIONSHIPS

8212: LOOP
8213: Begin
8214: select relationship_id,object_id
8215: into l_relationship_id,l_object_id
8216: from CSI_II_RELATIONSHIPS
8217: where subject_id = l_subject_id
8218: and relationship_type_code = l_rel_type_code
8219: and ((active_end_date is null) or (active_end_date > sysdate));
8220: --

Line 8306: FROM csi_ii_relationships

8302: /*
8303: CURSOR Lx_Csr_PARPROD (Cx_CovProd_Id IN Gx_OKS_Id ) IS
8304: SELECT object_id,
8305: subject_id
8306: FROM csi_ii_relationships
8307: connect by prior object_id = subject_id
8308: start with subject_id = Cx_CovProd_Id
8309: UNION
8310: SELECT instance_id object_id,