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 3225: , CS_COUNTER_GROUPS counter_groups

3221: CURSOR l_counter_csr ( b_ctr_grp_id NUMBER)
3222: IS
3223: SELECT counters.COUNTER_ID
3224: FROM CS_COUNTERS counters
3225: , CS_COUNTER_GROUPS counter_groups
3226: WHERE counters.counter_group_id = counter_groups.counter_group_id
3227: AND counter_groups.counter_group_id = b_ctr_grp_id
3228: AND counters.TYPE = 'REGULAR';
3229:

Line 3235: FROM CS_COUNTER_GROUPS counter_groups

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

Line 3316: FROM CS_COUNTER_GROUPS counter_groups,

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

Line 3378: , CS_COUNTER_GROUPS counter_groups

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

Line 3477: , CS_COUNTER_GROUPS counter_groups

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

Line 3488: , CS_COUNTER_GROUPS counter_groups

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

Line 3532: , CS_COUNTER_GROUPS counter_groups

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