APPS.ASG_DEFER dependencies on ASG_PUB

Line 603: l_pub_handler asg_pub.wrapper_name%type;

599: x_return_status OUT NOCOPY VARCHAR2)
600: IS
601: counter PLS_INTEGER;
602: sql_string VARCHAR2(4000);
603: l_pub_handler asg_pub.wrapper_name%type;
604: l_pubname VARCHAR2(30);
605: l_pubitems_tbl asg_apply.vc2_tbl_type;
606: l_def_trans VARCHAR2(1);
607: l_return_status VARCHAR2(1);

Line 619: FROM asg_pub a, asg_pub_item b, asg_deferred_traninfo c

615: l_orig_resp_id NUMBER;
616: l_orig_app_id NUMBER;
617: CURSOR c_pub_wrapper(p_user_name VARCHAR2, p_tranid NUMBER) IS
618: SELECT distinct a.wrapper_name, a.name
619: FROM asg_pub a, asg_pub_item b, asg_deferred_traninfo c
620: WHERE device_user_name = p_user_name AND
621: deferred_tran_id = p_tranid AND
622: c.object_name = b.name AND
623: b.pub_name = a.name