APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPE_ORGN_ACTIVITIES

Line 637: FROM gmd_recipe_orgn_activities

633: X_vr_tbl rcp_vr;
634:
635: CURSOR Cur_get_actv IS
636: SELECT *
637: FROM gmd_recipe_orgn_activities
638: WHERE recipe_id = p_recipe_id;
639: TYPE rcp_actv IS TABLE OF Cur_get_actv%ROWTYPE INDEX BY BINARY_INTEGER;
640: X_actv_tbl rcp_actv;
641:

Line 885: INSERT INTO gmd_recipe_orgn_activities(recipe_id, routingstep_id, activity_factor, attribute_category, attribute1,

881:
882: -- Bug 3037410 Mohit Kapoor Added the if statement
883: IF p_routing_id is NULL THEN
884: FOR i IN 1..X_actv_tbl.count LOOP
885: INSERT INTO gmd_recipe_orgn_activities(recipe_id, routingstep_id, activity_factor, attribute_category, attribute1,
886: created_by, creation_date, last_updated_by, last_update_date,
887: last_update_login, orgn_code, attribute2, attribute3, attribute4, attribute5,
888: attribute6, attribute7, attribute8, attribute9, attribute10, attribute11,
889: attribute12, attribute13, attribute14, attribute15, attribute16, attribute17,