APPS.AHL_UC_UNITCONFIG_PVT dependencies on CSI_II_RELATIONSHIPS

Line 423: FROM csi_ii_relationships I

419:
420: -- SATHAPLI::Bug# 5347338 fix
421: /*
422: AND NOT EXISTS (SELECT 'X'
423: FROM csi_ii_relationships I
424: WHERE I.subject_id = C.instance_id
425: AND I.relationship_type_code = 'COMPONENT-OF'
426: AND trunc(nvl(I.active_start_date,SYSDATE)) <= trunc(SYSDATE)
427: AND trunc(nvl(I.active_end_date, SYSDATE+1)) > trunc(SYSDATE))

Line 455: FROM csi_ii_relationships I

451:
452: -- SATHAPLI::Bug# 5347338 fix
453: /*
454: AND NOT EXISTS (SELECT 'X'
455: FROM csi_ii_relationships I
456: WHERE I.subject_id = C.instance_id
457: AND I.relationship_type_code = 'COMPONENT-OF'
458: AND trunc(nvl(I.active_start_date,SYSDATE)) <= trunc(SYSDATE)
459: AND trunc(nvl(I.active_end_date, SYSDATE+1)) > trunc(SYSDATE))

Line 1216: FROM csi_ii_relationships

1212:
1213: CURSOR get_csi_ii_relationship(c_instance_id NUMBER) IS
1214: SELECT relationship_id,
1215: object_version_number
1216: FROM csi_ii_relationships
1217: WHERE subject_id = c_instance_id
1218: AND relationship_type_code='COMPONENT-OF'
1219: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
1220: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 1365: CSI_II_RELATIONSHIPS_PUB.expire_relationship(

1361:
1362: --Set CSI relationship record
1363: l_csi_relationship_rec.relationship_id := l_csi_relationship_id;
1364: l_csi_relationship_rec.object_version_number := l_object_version_number;
1365: CSI_II_RELATIONSHIPS_PUB.expire_relationship(
1366: p_api_version => 1.0,
1367: p_relationship_rec => l_csi_relationship_rec,
1368: p_txn_rec => l_csi_transaction_rec,
1369: x_instance_id_lst => l_csi_instance_id_lst,