APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on CSI_II_RELATIONSHIPS

Line 648: FROM CSI_II_RELATIONSHIPS

644: )
645: IS
646: CURSOR c_child_instance ( b_instance_id NUMBER ) IS
647: SELECT subject_id
648: FROM CSI_II_RELATIONSHIPS
649: WHERE RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
650: START WITH object_id = b_instance_id
651: CONNECT BY PRIOR subject_id = object_id;
652: r_child_instance c_child_instance%ROWTYPE;

Line 708: FROM CSI_II_RELATIONSHIPS

704: )
705: IS
706: CURSOR c_parent_instance ( b_instance_id NUMBER ) IS
707: SELECT object_id
708: FROM CSI_II_RELATIONSHIPS
709: WHERE RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
710: AND SUBJECT_ID = b_instance_id;
711: r_parent_instance c_parent_instance%ROWTYPE;
712:

Line 833: SELECT subject_id FROM CSI_II_RELATIONSHIPS

829: SELECT acc.instance_id FROM CSL_CSI_ITEM_INSTANCES_ACC acc
830: WHERE acc.resource_id = b_resource_id AND
831: acc.instance_id IN
832: (
833: SELECT subject_id FROM CSI_II_RELATIONSHIPS
834: WHERE RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
835: START WITH object_id = b_instance_id
836: CONNECT BY PRIOR subject_id = object_id
837: )

Line 960: FROM CSI_II_RELATIONSHIPS

956: )
957: IS
958: CURSOR c_child_instance ( b_instance_id NUMBER ) IS
959: SELECT subject_id
960: FROM CSI_II_RELATIONSHIPS
961: WHERE RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
962: START WITH object_id = b_instance_id
963: CONNECT BY PRIOR subject_id = object_id;
964: r_child_instance c_child_instance%ROWTYPE;

Line 1018: FROM CSI_II_RELATIONSHIPS

1014: )
1015: IS
1016: CURSOR c_parent_instance ( b_instance_id NUMBER ) IS
1017: SELECT object_id
1018: FROM CSI_II_RELATIONSHIPS
1019: WHERE RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1020: AND SUBJECT_ID = b_instance_id;
1021: r_parent_instance c_parent_instance%ROWTYPE;
1022:

Line 1313: , CSI_II_RELATIONSHIPS cir

1309:
1310: CURSOR c_is_parent( b_instance_id NUMBER ) IS
1311: SELECT cia.resource_id
1312: FROM CSL_CSI_ITEM_INSTANCES_ACC cia
1313: , CSI_II_RELATIONSHIPS cir
1314: WHERE cir.relationship_type_code = 'COMPONENT-OF'
1315: AND cir.subject_id = cia.instance_id
1316: AND cir.object_id = b_instance_id;
1317:

Line 1321: , CSI_II_RELATIONSHIPS cir

1317:
1318: CURSOR c_is_child( b_instance_id NUMBER ) IS
1319: SELECT cia.resource_id
1320: FROM CSL_CSI_ITEM_INSTANCES_ACC cia
1321: , CSI_II_RELATIONSHIPS cir
1322: WHERE cir.relationship_type_code = 'COMPONENT-OF'
1323: AND cir.object_id = cia.instance_id
1324: AND cir.subject_id = b_instance_id;
1325: