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 1220: FROM csi_ii_relationships

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

Line 1369: CSI_II_RELATIONSHIPS_PUB.expire_relationship(

1365:
1366: --Set CSI relationship record
1367: l_csi_relationship_rec.relationship_id := l_csi_relationship_id;
1368: l_csi_relationship_rec.object_version_number := l_object_version_number;
1369: CSI_II_RELATIONSHIPS_PUB.expire_relationship(
1370: p_api_version => 1.0,
1371: p_relationship_rec => l_csi_relationship_rec,
1372: p_txn_rec => l_csi_transaction_rec,
1373: x_instance_id_lst => l_csi_instance_id_lst,