eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_WF_PKG dependencies on CS_COUNTER_GROUPS

Line 3255: , CS_COUNTER_GROUPS counter_groups

3251: CURSOR l_counter_csr ( b_ctr_grp_id NUMBER)
3252: IS
3253: SELECT counters.COUNTER_ID
3254: FROM CS_COUNTERS counters
3255: , CS_COUNTER_GROUPS counter_groups
3256: WHERE counters.counter_group_id = counter_groups.counter_group_id
3257: AND counter_groups.counter_group_id = b_ctr_grp_id
3258: AND counters.TYPE = 'REGULAR';
3259:

Line 3265: FROM CS_COUNTER_GROUPS counter_groups

3261: ,b_source_object_id NUMBER
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

Line 3346: FROM CS_COUNTER_GROUPS counter_groups,

3342: CURSOR l_acc_csr (b_source_object_cd VARCHAR2
3343: ,b_source_object_id NUMBER)
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

Line 3408: , CS_COUNTER_GROUPS counter_groups

3404: CURSOR l_counter_csr ( b_ctr_grp_id NUMBER)
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'

Line 3507: , CS_COUNTER_GROUPS counter_groups

3503:
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)

Line 3518: , CS_COUNTER_GROUPS counter_groups

3514:
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)

Line 3562: , CS_COUNTER_GROUPS counter_groups

3558:
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