APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPE_CUSTOMERS

Line 615: FROM gmd_recipe_customers

611: X_proc_loss_tbl proc_loss;
612:
613: CURSOR Cur_get_cust IS
614: SELECT *
615: FROM gmd_recipe_customers
616: WHERE recipe_id = p_recipe_id;
617: TYPE rcp_cust IS TABLE OF Cur_get_cust%ROWTYPE INDEX BY BINARY_INTEGER;
618: X_cust_tbl rcp_cust;
619:

Line 804: INSERT INTO gmd_recipe_customers(recipe_id, customer_id, created_by, creation_date, last_updated_by,

800: X_proc_loss_tbl(i).contiguous_ind, SYSDATE, P_created_by, P_created_by, SYSDATE, P_login_id,
801: gmd_recipe_process_loss_id_s.NEXTVAL, X_proc_loss_tbl(i).text_code);
802: END LOOP;
803: FOR i IN 1..X_cust_tbl.count LOOP
804: INSERT INTO gmd_recipe_customers(recipe_id, customer_id, created_by, creation_date, last_updated_by,
805: last_update_login, text_code, last_update_date)
806: VALUES (x_recipe_id, X_cust_tbl(i).customer_id, P_created_by, SYSDATE,
807: P_created_by, P_login_id, X_cust_tbl(i).text_code, SYSDATE);
808: END LOOP;