DBA Data[Home] [Help]

APPS.AMS_COPYELEMENTS_PVT dependencies on AMS_ACT_DELIVERY_METHODS

Line 1996: FROM ams_act_delivery_methods

1992:
1993: CURSOR deliv_method_cur
1994: IS
1995: SELECT *
1996: FROM ams_act_delivery_methods
1997: WHERE act_delivery_method_used_by_id = p_src_act_id
1998: AND arc_act_delivery_used_by = p_src_act_type;
1999: BEGIN
2000: p_errcode := NULL;

Line 3689: FROM ams_act_delivery_methods

3685: WHERE event_offer_id = event_id ;
3686:
3687: CURSOR c_delivery (delv_id NUMBER) IS
3688: SELECT delivery_media_type_code
3689: FROM ams_act_delivery_methods
3690: WHERE activity_delivery_method_id = delv_id;
3691:
3692: -- soagrawa 22-oct-2002 for bug# 2594717
3693: CURSOR c_eone_srccd(event_id NUMBER) IS