APPS.CSM_WF_PKG dependencies on CSM_ITEM_INSTANCES_ACC

Line 3266: , csm_item_instances_acc acc

3262: ,b_ctr_grp_id NUMBER)
3263: IS
3264: SELECT COUNT(1)
3265: FROM CS_COUNTER_GROUPS counter_groups
3266: , csm_item_instances_acc acc
3267: WHERE b_source_object_cd = 'CP'
3268: AND counter_groups.counter_group_id = b_ctr_grp_id
3269: AND counter_groups.source_object_code = b_source_object_cd
3270: AND acc.instance_id = counter_groups.source_object_id

Line 3348: csm_item_instances_acc acc

3344: IS
3345: SELECT counters.counter_id
3346: FROM CS_COUNTER_GROUPS counter_groups,
3347: cs_counters counters,
3348: csm_item_instances_acc acc
3349: WHERE counter_groups.source_object_code = b_source_object_cd
3350: AND counter_groups.source_object_id = b_source_object_id
3351: AND acc.instance_id = counter_groups.source_object_id
3352: AND counters.counter_group_id = counter_groups.counter_group_id

Line 3409: , csm_item_instances_acc acc

3405: IS
3406: SELECT counters.counter_id
3407: FROM CS_COUNTERS counters
3408: , CS_COUNTER_GROUPS counter_groups
3409: , csm_item_instances_acc acc
3410: WHERE counter_groups.counter_group_id = b_ctr_grp_id
3411: AND counters.counter_group_id = counter_groups.counter_group_id
3412: AND counter_groups.source_object_code = 'CP'
3413: AND acc.instance_id = counter_groups.source_object_id;

Line 3508: , csm_item_instances_acc acc

3504: /* CURSOR l_acc_del_csr(b_counter_id NUMBER) IS
3505: SELECT acc.user_id
3506: FROM CS_COUNTERS counters
3507: , CS_COUNTER_GROUPS counter_groups
3508: , csm_item_instances_acc acc
3509: WHERE counters.counter_group_id = counter_groups.counter_group_id
3510: AND counter_groups.source_object_code = 'CP'
3511: AND SYSDATE NOT BETWEEN NVL(counters.start_date_active, SYSDATE) AND NVL(counters.end_date_active, SYSDATE)
3512: and acc.instance_id = counter_groups.source_object_id

Line 3519: , csm_item_instances_acc acc

3515: CURSOR l_acc_upd_csr(b_counter_id NUMBER) IS
3516: SELECT acc.user_id
3517: FROM CS_COUNTERS counters
3518: , CS_COUNTER_GROUPS counter_groups
3519: , csm_item_instances_acc acc
3520: WHERE counters.counter_group_id = counter_groups.counter_group_id
3521: AND counter_groups.source_object_code = 'CP'
3522: AND SYSDATE BETWEEN NVL(counters.start_date_active, SYSDATE) AND NVL(counters.end_date_active, SYSDATE)
3523: and acc.instance_id = counter_groups.source_object_id

Line 3563: , csm_item_instances_acc acc

3559: CURSOR l_acc_csr(b_counter_id NUMBER) IS
3560: SELECT COUNT(1)
3561: FROM CS_COUNTERS counters
3562: , CS_COUNTER_GROUPS counter_groups
3563: , csm_item_instances_acc acc
3564: WHERE counters.counter_group_id = counter_groups.counter_group_id
3565: AND counter_groups.source_object_code = 'CP'
3566: AND acc.instance_id = counter_groups.source_object_id
3567: AND counters.counter_id = b_counter_id;