APPS.AMS_SCHEDULERULES_PVT dependencies on IBC_CONTENT_ITEMS

Line 1990: FROM ibc_associations assoc, ibc_content_Items ci

1986:
1987: -- soagrawa added the following cursor on 30-sep-2003 for stamping version in 11.5.10
1988: CURSOR c_cover_letter_det IS
1989: SELECT ci.live_citem_version_id
1990: FROM ibc_associations assoc, ibc_content_Items ci
1991: WHERE assoc.association_type_code = 'AMS_CSCH'
1992: AND assoc.associated_object_val1 = to_char(p_schedule_id) -- fix for bug # 4145845
1993: AND assoc.content_item_id = ci.content_Item_id;
1994:

Line 2958: , ibc_content_items ci

2954: -- for approving item
2955: CURSOR c_template_det (p_content_item_id NUMBER)
2956: IS SELECT ver.citem_version_id, ver.object_version_number, ci.content_item_status
2957: FROM ibc_citem_versions_vl ver
2958: , ibc_content_items ci
2959: WHERE ci.content_item_id = p_content_item_id
2960: AND ci.content_item_id = ver.content_item_id;
2961: */
2962:

Line 4024: FROM ibc_associations assoc, ibc_content_Items ci

4020:
4021: -- soagrawa added the following cursor on 30-sep-2003 for stamping version
4022: CURSOR c_cover_letter_det (l_csch_id IN NUMBER) IS
4023: SELECT assoc.association_id, assoc.content_item_id, ci.live_citem_version_id
4024: FROM ibc_associations assoc, ibc_content_Items ci
4025: WHERE assoc.association_type_code = 'AMS_CSCH'
4026: AND assoc.associated_object_val1 = to_char(l_csch_id) -- fix for bug # 4145845
4027: AND assoc.content_item_id = ci.content_Item_id;
4028:

Line 6053: FROM ibc_associations assoc, ibc_content_Items ci

6049: l_log_return_status VARCHAR2(1) := FND_API.g_ret_sts_success ;
6050:
6051: CURSOR c_citem_assoc (l_csch_id IN NUMBER) IS
6052: SELECT assoc.association_id, assoc.content_item_id, ci.live_citem_version_id
6053: FROM ibc_associations assoc, ibc_content_Items ci
6054: WHERE assoc.association_type_code in ('AMS_CSCH','AMS_COLLAT')
6055: AND assoc.associated_object_val1 = to_char(l_csch_id)
6056: AND assoc.content_item_id = ci.content_Item_id;
6057: