APPS.CSM_WF_PKG dependencies on CSM_ITEM_INSTANCES_ACC

Line 3236: , csm_item_instances_acc acc

3232: ,b_ctr_grp_id NUMBER)
3233: IS
3234: SELECT COUNT(1)
3235: FROM CS_COUNTER_GROUPS counter_groups
3236: , csm_item_instances_acc acc
3237: WHERE b_source_object_cd = 'CP'
3238: AND counter_groups.counter_group_id = b_ctr_grp_id
3239: AND counter_groups.source_object_code = b_source_object_cd
3240: AND acc.instance_id = counter_groups.source_object_id

Line 3318: csm_item_instances_acc acc

3314: IS
3315: SELECT counters.counter_id
3316: FROM CS_COUNTER_GROUPS counter_groups,
3317: cs_counters counters,
3318: csm_item_instances_acc acc
3319: WHERE counter_groups.source_object_code = b_source_object_cd
3320: AND counter_groups.source_object_id = b_source_object_id
3321: AND acc.instance_id = counter_groups.source_object_id
3322: AND counters.counter_group_id = counter_groups.counter_group_id

Line 3379: , csm_item_instances_acc acc

3375: IS
3376: SELECT counters.counter_id
3377: FROM CS_COUNTERS counters
3378: , CS_COUNTER_GROUPS counter_groups
3379: , csm_item_instances_acc acc
3380: WHERE counter_groups.counter_group_id = b_ctr_grp_id
3381: AND counters.counter_group_id = counter_groups.counter_group_id
3382: AND counter_groups.source_object_code = 'CP'
3383: AND acc.instance_id = counter_groups.source_object_id;

Line 3478: , csm_item_instances_acc acc

3474: /* CURSOR l_acc_del_csr(b_counter_id NUMBER) IS
3475: SELECT acc.user_id
3476: FROM CS_COUNTERS counters
3477: , CS_COUNTER_GROUPS counter_groups
3478: , csm_item_instances_acc acc
3479: WHERE counters.counter_group_id = counter_groups.counter_group_id
3480: AND counter_groups.source_object_code = 'CP'
3481: AND SYSDATE NOT BETWEEN NVL(counters.start_date_active, SYSDATE) AND NVL(counters.end_date_active, SYSDATE)
3482: and acc.instance_id = counter_groups.source_object_id

Line 3489: , csm_item_instances_acc acc

3485: CURSOR l_acc_upd_csr(b_counter_id NUMBER) IS
3486: SELECT acc.user_id
3487: FROM CS_COUNTERS counters
3488: , CS_COUNTER_GROUPS counter_groups
3489: , csm_item_instances_acc acc
3490: WHERE counters.counter_group_id = counter_groups.counter_group_id
3491: AND counter_groups.source_object_code = 'CP'
3492: AND SYSDATE BETWEEN NVL(counters.start_date_active, SYSDATE) AND NVL(counters.end_date_active, SYSDATE)
3493: and acc.instance_id = counter_groups.source_object_id

Line 3533: , csm_item_instances_acc acc

3529: CURSOR l_acc_csr(b_counter_id NUMBER) IS
3530: SELECT COUNT(1)
3531: FROM CS_COUNTERS counters
3532: , CS_COUNTER_GROUPS counter_groups
3533: , csm_item_instances_acc acc
3534: WHERE counters.counter_group_id = counter_groups.counter_group_id
3535: AND counter_groups.source_object_code = 'CP'
3536: AND acc.instance_id = counter_groups.source_object_id
3537: AND counters.counter_id = b_counter_id;