DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on CSI_II_RELATIONSHIPS

Line 8604: from CSI_II_RELATIONSHIPS

8600: LOOP
8601: Begin
8602: select relationship_id,object_id
8603: into l_relationship_id,l_object_id
8604: from CSI_II_RELATIONSHIPS
8605: where subject_id = l_subject_id
8606: and relationship_type_code = l_rel_type_code
8607: and ((active_end_date is null) or (active_end_date > sysdate));
8608: --

Line 8694: FROM csi_ii_relationships

8690: /*
8691: CURSOR Lx_Csr_PARPROD (Cx_CovProd_Id IN Gx_OKS_Id ) IS
8692: SELECT object_id,
8693: subject_id
8694: FROM csi_ii_relationships
8695: connect by prior object_id = subject_id
8696: start with subject_id = Cx_CovProd_Id
8697: UNION
8698: SELECT instance_id object_id,