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 2946: , ibc_content_items ci

2942: -- for approving item
2943: CURSOR c_template_det (p_content_item_id NUMBER)
2944: IS SELECT ver.citem_version_id, ver.object_version_number, ci.content_item_status
2945: FROM ibc_citem_versions_vl ver
2946: , ibc_content_items ci
2947: WHERE ci.content_item_id = p_content_item_id
2948: AND ci.content_item_id = ver.content_item_id;
2949: */
2950:

Line 3994: FROM ibc_associations assoc, ibc_content_Items ci

3990:
3991: -- soagrawa added the following cursor on 30-sep-2003 for stamping version
3992: CURSOR c_cover_letter_det (l_csch_id IN NUMBER) IS
3993: SELECT assoc.association_id, assoc.content_item_id, ci.live_citem_version_id
3994: FROM ibc_associations assoc, ibc_content_Items ci
3995: WHERE assoc.association_type_code = 'AMS_CSCH'
3996: AND assoc.associated_object_val1 = to_char(l_csch_id) -- fix for bug # 4145845
3997: AND assoc.content_item_id = ci.content_Item_id;
3998:

Line 6023: FROM ibc_associations assoc, ibc_content_Items ci

6019: l_log_return_status VARCHAR2(1) := FND_API.g_ret_sts_success ;
6020:
6021: CURSOR c_citem_assoc (l_csch_id IN NUMBER) IS
6022: SELECT assoc.association_id, assoc.content_item_id, ci.live_citem_version_id
6023: FROM ibc_associations assoc, ibc_content_Items ci
6024: WHERE assoc.association_type_code in ('AMS_CSCH','AMS_COLLAT')
6025: AND assoc.associated_object_val1 = to_char(l_csch_id)
6026: AND assoc.content_item_id = ci.content_Item_id;
6027: