APPS.JTM_CON_QUERY_REQUEST_PKG dependencies on ASG_PUB_ITEM

Line 23: FROM asg_pub_item pubitm

19:
20: /*** cursor retriving the primary key of pub_item associated with this query ***/
21: CURSOR c_primary_key(b_con_query_id NUMBER) IS
22: SELECT distinct pubitm.primary_key_column
23: FROM asg_pub_item pubitm
24: , jtm_pub_acc pubacc
25: WHERE pubacc.publication_item_name = pubitm.name
26: AND pubacc.con_query_id = b_con_query_id
27: AND pubacc.execute_flag = 'Y'

Line 38: , asg_pub_item api

34: IS
35: SELECT au.resource_id
36: FROM asg_user au
37: , asg_user_pub_resps aupr
38: , asg_pub_item api
39: WHERE au.user_name = aupr.user_name
40: AND aupr.pub_name = api.pub_name
41: AND api.name = b_pub_item_name
42: AND au.enabled = 'Y'