101: CURSOR c_csm_acc_list IS
102: SELECT ITEM_ID,
103: ACCESS_OWNER,
104: ACCESS_NAME
105: FROM ASG_PUB_ITEM
106: WHERE PUB_NAME IN ('SERVICEP','JTM_HANDHELD')
107: AND ACCESS_NAME IS NOT NULL
108: AND STATUS = 'Y'
109: AND ENABLED = 'Y';
111: CURSOR c_csl_acc_list IS
112: SELECT ITEM_ID,
113: ACCESS_OWNER,
114: ACCESS_NAME
115: FROM ASG_PUB_ITEM
116: WHERE PUB_NAME IN ('JTM','SERVICEL')
117: AND ACCESS_NAME IS NOT NULL
118: AND STATUS = 'Y'
119: AND ENABLED = 'Y';