APPS.OKS_AUTH_UTIL_PUB dependencies on CSI_COUNTERS_B

Line 371: csi_counters_b ccb, csi_counter_associations cca

367: AND a.source_object_code = 'CONTRACT_LINE'
368: AND(
369: (a.template_flag = 'Y') OR
370: (a.template_flag = 'N' AND EXISTS (select 1 from
371: csi_counters_b ccb, csi_counter_associations cca
372: where a.counter_group_id = ccb.group_id AND
373: ccb.counter_id = cca.counter_id))
374: );*/
375:

Line 378: csi_counters_b ccb, csi_counter_associations cca

374: );*/
375:
376: SELECT a.template_flag
377: FROM cs_csi_counter_groups a,
378: csi_counters_b ccb, csi_counter_associations cca
379: WHERE a.counter_group_id = ccb.group_id AND
380: ccb.counter_id = cca.counter_id AND
381: cca.source_object_id = p_cle_id AND
382: cca.source_object_code = 'CONTRACT_LINE';

Line 395: SELECT counter_id FROM CSI_COUNTERS_B) temp

391: SELECT COUNT(temp.counter_id) cnt
392: FROM
393: (SELECT counter_id FROM CSI_COUNTER_TEMPLATE_B
394: UNION ALL
395: SELECT counter_id FROM CSI_COUNTERS_B) temp
396: WHERE temp.counter_id = p_object1_id1;
397:
398: get_ctr_rec get_ctr_csr%ROWTYPE;
399: