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.CSC_PROFILE_ENGINE_PKG dependencies on CSC_PROF_GROUP_CHECKS

Line 1002: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks)

998: SELECT check_id, select_type, select_block_id,
999: data_type, format_mask,check_upper_lower_flag,
1000: threshold_grade, check_level
1001: FROM csc_prof_checks_b a
1002: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks)
1003: AND select_type = 'B'
1004: AND CHECK_ID =42
1005: AND check_level IN ('PARTY',
1006: 'ACCOUNT',

Line 2383: FROM csc_prof_group_checks a

2379: )
2380: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2381: AND nvl(end_date_active, Sysdate))
2382: AND EXISTS ( SELECT a.check_id
2383: FROM csc_prof_group_checks a
2384: WHERE a.group_id = p_group_id
2385: AND chk.check_id = a.check_id);
2386:
2387: /* added cursor checks_crit_csr for JIT enhancement -- Bug 4535407 */

Line 2405: FROM csc_prof_group_checks a

2401: )
2402: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2403: AND nvl(end_date_active, Sysdate))
2404: AND EXISTS ( SELECT a.check_id
2405: FROM csc_prof_group_checks a
2406: WHERE a.group_id = p_group_id
2407: AND chk.check_id = a.check_id
2408: AND a.critical_flag = 'Y');
2409:

Line 2439: FROM csc_prof_group_checks a

2435: )
2436: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2437: AND nvl(end_date_active, Sysdate))
2438: AND EXISTS ( SELECT a.check_id
2439: FROM csc_prof_group_checks a
2440: WHERE a.group_id = p_group_id
2441: AND chk.check_id = a.check_id);
2442:
2443: /* added cursor checks_csr_jit for JIT enhancement -- Bug 4535407 */

Line 2460: FROM csc_prof_group_checks a

2456: )
2457: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2458: AND nvl(end_date_active, Sysdate))
2459: AND EXISTS ( SELECT a.check_id
2460: FROM csc_prof_group_checks a
2461: WHERE a.group_id = p_group_id
2462: AND chk.check_id = a.check_id
2463: AND a.critical_flag = 'Y');
2464:

Line 2480: FROM csc_prof_group_checks a

2476: WHERE check_level = 'EMPLOYEE'
2477: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2478: AND nvl(end_date_active, Sysdate))
2479: AND EXISTS ( SELECT a.check_id
2480: FROM csc_prof_group_checks a
2481: WHERE a.group_id = p_group_id
2482: AND chk.check_id = a.check_id);
2483:
2484: CURSOR emp_checks_crit_csr IS

Line 2498: FROM csc_prof_group_checks a

2494: WHERE check_level = 'EMPLOYEE'
2495: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2496: AND nvl(end_date_active, Sysdate))
2497: AND EXISTS ( SELECT a.check_id
2498: FROM csc_prof_group_checks a
2499: WHERE a.group_id = p_group_id
2500: AND chk.check_id = a.check_id
2501: AND a.critical_flag = 'Y');
2502:

Line 2761: FROM csc_prof_group_checks a

2757: )
2758: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2759: AND nvl(end_date_active, Sysdate))
2760: AND Exists ( SELECT a.check_id
2761: FROM csc_prof_group_checks a
2762: WHERE chk.check_id = a.check_id
2763: AND sysdate between
2764: nvl(a.start_date_active,sysdate)
2765: AND nvl(a.end_date_active,sysdate));

Line 2781: FROM csc_prof_group_checks a

2777: WHERE check_level IN ('EMPLOYEE')
2778: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2779: AND nvl(end_date_active, Sysdate))
2780: AND Exists ( SELECT a.check_id
2781: FROM csc_prof_group_checks a
2782: WHERE chk.check_id = a.check_id
2783: AND sysdate between
2784: nvl(a.start_date_active,sysdate)
2785: AND nvl(a.end_date_active,sysdate));

Line 2835: FROM csc_prof_group_checks a

2831: )
2832: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2833: AND nvl(end_date_active, Sysdate))
2834: AND Exists ( SELECT a.check_id
2835: FROM csc_prof_group_checks a
2836: WHERE chk.check_id = a.check_id
2837: AND sysdate between nvl(a.start_date_active,sysdate)
2838: AND nvl(a.end_date_active,sysdate));
2839:

Line 3743: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

3739: format_mask,
3740: check_upper_lower_flag,
3741: threshold_grade
3742: FROM csc_prof_checks_b
3743: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
3744: WHERE group_id = p_group_id)
3745: AND SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
3746: AND Nvl(end_date_active, Sysdate)
3747: AND select_type = 'B'

Line 3760: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

3756: format_mask,
3757: check_upper_lower_flag,
3758: threshold_grade
3759: FROM csc_prof_checks_b
3760: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
3761: WHERE group_id = p_group_id)
3762: AND SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
3763: AND Nvl(end_date_active, Sysdate)
3764: AND select_type = 'B'

Line 3777: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

3773: format_mask,
3774: check_upper_lower_flag,
3775: threshold_grade
3776: FROM csc_prof_checks_b
3777: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
3778: WHERE group_id = p_group_id)
3779: AND SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
3780: AND Nvl(end_date_active, Sysdate)
3781: AND select_type = 'B'

Line 4063: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

4059: results_threshold_flag,
4060: rating_code,
4061: color_code
4062: FROM csc_prof_check_results
4063: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
4064: MINUS
4065: SELECT check_id FROM csc_prof_group_checks a
4066: WHERE group_id = p_group_id
4067: AND EXISTS (SELECT 1 FROM csc_prof_checks_b b

Line 4065: SELECT check_id FROM csc_prof_group_checks a

4061: color_code
4062: FROM csc_prof_check_results
4063: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
4064: MINUS
4065: SELECT check_id FROM csc_prof_group_checks a
4066: WHERE group_id = p_group_id
4067: AND EXISTS (SELECT 1 FROM csc_prof_checks_b b
4068: WHERE a.check_id = b.check_id AND b.select_type = 'B'));
4069: COMMIT;

Line 4228: FROM csc_prof_group_checks

4224: threshold_grade,
4225: check_level
4226: FROM csc_prof_checks_b a
4227: WHERE check_id IN (SELECT check_id
4228: FROM csc_prof_group_checks
4229: WHERE group_id = p_group_id)
4230: AND select_type = 'B'
4231: AND check_level IN ('PARTY','ACCOUNT','SITE') -- Included the 'SITE' by spamujul for ER#8473903
4232: AND EXISTS (SELECT null

Line 4670: from csc_prof_group_checks

4666: threshold_grade,
4667: check_level
4668: FROM csc_prof_checks_b
4669: WHERE check_id in (select check_id
4670: from csc_prof_group_checks
4671: where group_id = p_group_id)
4672: AND check_level IN ('PARTY','ACCOUNT','SITE') -- Included by spamujul for ER#8473903
4673: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
4674: AND Nvl(end_date_active, Sysdate)

Line 4680: from csc_prof_group_checks

4676: CURSOR checks_count IS
4677: SELECT COUNT(*)
4678: FROM csc_prof_checks_b
4679: WHERE check_id in (select check_id
4680: from csc_prof_group_checks
4681: where group_id = p_group_id)
4682: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
4683: AND Nvl(end_date_active, Sysdate)
4684: AND select_type = 'T';

Line 6127: AND check_id IN (SELECT check_id FROM csc_prof_group_checks))

6123: WHERE EXISTS ( SELECT null
6124: FROM csc_prof_checks_b b
6125: WHERE b.select_block_id = a.block_id
6126: AND b.select_type = 'B'
6127: AND check_id IN (SELECT check_id FROM csc_prof_group_checks))
6128: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
6129: AND Nvl(end_date_active, SYSDATE)
6130: AND batch_sql_stmnt IS NULL;
6131:

Line 6718: from csc_prof_group_checks

6714: From csc_prof_check_rules_b b
6715: where (b.block_id = a.block_id
6716: or b.expr_to_block_id = a.block_id)
6717: And check_id in (Select check_id
6718: from csc_prof_group_checks
6719: where group_id = p_group_id))
6720: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
6721: AND Nvl(end_date_active, Sysdate)
6722: AND block_level IN ('PARTY','ACCOUNT','SITE') -- Included by spamujul for ER#8473903

Line 7006: AND check_id IN (SELECT check_id FROM csc_prof_group_checks

7002: WHERE EXISTS ( SELECT null
7003: FROM csc_prof_checks_b b
7004: WHERE b.select_block_id = a.block_id
7005: AND b.select_type = 'B'
7006: AND check_id IN (SELECT check_id FROM csc_prof_group_checks
7007: WHERE group_id = p_group_id))
7008: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
7009: AND Nvl(end_date_active, SYSDATE)
7010: AND batch_sql_stmnt IS NULL;

Line 7482: AND check_id IN (SELECT check_id FROM csc_prof_group_checks))

7478: WHERE EXISTS ( SELECT null
7479: FROM csc_prof_checks_b b
7480: WHERE b.select_block_id = a.block_id
7481: AND b.select_type = 'B'
7482: AND check_id IN (SELECT check_id FROM csc_prof_group_checks))
7483: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
7484: AND Nvl(end_date_active, SYSDATE)
7485: AND batch_sql_stmnt IS NULL
7486: AND block_level IN ( 'CONTACT','SITE'); -- Included 'SITE' by spamujul for ER#8473903

Line 7527: AND check_id IN (SELECT check_id FROM csc_prof_group_checks

7523: WHERE EXISTS ( SELECT null
7524: FROM csc_prof_checks_b b
7525: WHERE b.select_block_id = a.block_id
7526: AND b.select_type = 'B'
7527: AND check_id IN (SELECT check_id FROM csc_prof_group_checks
7528: WHERE group_id = p_group_id))
7529: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
7530: AND Nvl(end_date_active, SYSDATE)
7531: AND batch_sql_stmnt IS NULL

Line 7545: AND b.check_id IN (SELECT check_id from csc_prof_group_checks

7541: WHERE (b.block_id = a.block_id
7542: OR b.expr_to_block_id = a.block_id)
7543: AND c.select_type = 'T'
7544: AND b.check_id = c.check_id
7545: AND b.check_id IN (SELECT check_id from csc_prof_group_checks
7546: WHERE group_id = p_group_id))
7547: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
7548: AND Nvl(end_date_active, Sysdate)
7549: AND block_level IN ('CONTACT','SITE'); -- Included 'SITE' by spamujul for ER#8473903

Line 7560: AND check_id IN (Select check_id from csc_prof_group_checks

7556: WHERE EXISTS ( SELECT b.block_id
7557: FROM csc_prof_check_rules_b b
7558: WHERE (b.block_id = a.block_id
7559: or b.expr_to_block_id = a.block_id)
7560: AND check_id IN (Select check_id from csc_prof_group_checks
7561: where group_id = p_group_id))
7562: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
7563: AND Nvl(end_date_active, Sysdate)
7564: AND block_level IN ('CONTACT','SITE'); -- Included 'SITE' by spamujul for ER#8473903

Line 7801: FROM csc_prof_group_checks)

7797: check_upper_lower_flag,
7798: threshold_grade, check_level
7799: FROM csc_prof_checks_b a
7800: WHERE check_id IN (SELECT check_id
7801: FROM csc_prof_group_checks)
7802: AND select_type = 'B'
7803: AND check_level IN ( 'CONTACT','SITE') -- Included by spamujul for ER#8473903
7804: AND EXISTS (SELECT null
7805: FROM csc_prof_blocks_b b

Line 7853: FROM csc_prof_group_checks

7849: threshold_grade,
7850: check_level
7851: FROM csc_prof_checks_b a
7852: WHERE check_id IN (SELECT check_id
7853: FROM csc_prof_group_checks
7854: WHERE group_id = p_group_id)
7855: AND select_type = 'B'
7856: AND check_level IN ( 'CONTACT','SITE') -- Included by spamujul for ER#8473903'
7857: AND EXISTS (SELECT null

Line 7877: from csc_prof_group_checks

7873: FROM csc_prof_checks_b
7874: WHERE check_level IN ( 'CONTACT','SITE') -- Included by spamujul for ER#8473903'
7875: AND select_type = 'T'
7876: AND check_id in (select check_id
7877: from csc_prof_group_checks
7878: where group_id = p_group_id)
7879: And Sysdate BETWEEN Nvl(start_date_active, Sysdate)
7880: AND Nvl(end_date_active, Sysdate);
7881: ELSE

Line 7893: AND check_id in (select check_id from csc_prof_group_checks

7889: threshold_grade,
7890: check_level
7891: FROM csc_prof_checks_b
7892: WHERE check_level IN ( 'CONTACT','SITE') -- Included by spamujul for ER#8473903'
7893: AND check_id in (select check_id from csc_prof_group_checks
7894: where group_id = p_group_id)
7895: And Sysdate BETWEEN Nvl(start_date_active, Sysdate)
7896: AND Nvl(end_date_active, Sysdate);
7897: END IF;

Line 8178: AND check_id IN (SELECT check_id FROM csc_prof_group_checks))

8174: WHERE EXISTS ( SELECT null
8175: FROM csc_prof_checks_b b
8176: WHERE b.select_block_id = a.block_id
8177: AND b.select_type = 'B'
8178: AND check_id IN (SELECT check_id FROM csc_prof_group_checks))
8179: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
8180: AND Nvl(end_date_active, SYSDATE)
8181: AND batch_sql_stmnt IS NULL
8182: AND block_level = 'EMPLOYEE';

Line 8217: AND check_id IN (SELECT check_id FROM csc_prof_group_checks

8213: WHERE EXISTS ( SELECT null
8214: FROM csc_prof_checks_b b
8215: WHERE b.select_block_id = a.block_id
8216: AND b.select_type = 'B'
8217: AND check_id IN (SELECT check_id FROM csc_prof_group_checks
8218: WHERE group_id = p_group_id))
8219: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
8220: AND Nvl(end_date_active, SYSDATE)
8221: AND batch_sql_stmnt IS NULL

Line 8233: AND b.check_id IN (SELECT check_id from csc_prof_group_checks

8229: WHERE (b.block_id = a.block_id
8230: OR b.expr_to_block_id = a.block_id)
8231: AND c.select_type = 'T'
8232: AND b.check_id = c.check_id
8233: AND b.check_id IN (SELECT check_id from csc_prof_group_checks
8234: WHERE group_id = p_group_id))
8235: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
8236: AND Nvl(end_date_active, Sysdate)
8237: AND block_level = 'EMPLOYEE';

Line 8246: AND check_id IN (Select check_id from csc_prof_group_checks

8242: WHERE EXISTS ( SELECT b.block_id
8243: FROM csc_prof_check_rules_b b
8244: WHERE (b.block_id = a.block_id
8245: or b.expr_to_block_id = a.block_id)
8246: AND check_id IN (Select check_id from csc_prof_group_checks
8247: where group_id = p_group_id))
8248: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
8249: AND Nvl(end_date_active, Sysdate)
8250: AND block_level ='EMPLOYEE';

Line 8412: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks)

8408: SELECT check_id, select_type, select_block_id,
8409: data_type, format_mask, check_upper_lower_flag,
8410: threshold_grade, check_level
8411: FROM csc_prof_checks_b a
8412: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks)
8413: AND select_type = 'B'
8414: AND check_level = 'EMPLOYEE'
8415: AND EXISTS (SELECT null
8416: FROM csc_prof_blocks_b b

Line 8448: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

8444: SELECT check_id, select_type, select_block_id,
8445: data_type, format_mask,check_upper_lower_flag,
8446: threshold_grade, check_level
8447: FROM csc_prof_checks_b a
8448: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
8449: WHERE group_id = p_group_id)
8450: AND select_type = 'B'
8451: AND check_level = 'EMPLOYEE'
8452: AND EXISTS (SELECT null

Line 8466: AND check_id in (select check_id from csc_prof_group_checks

8462: check_level
8463: FROM csc_prof_checks_b
8464: WHERE check_level = 'EMPLOYEE'
8465: AND select_type = 'T'
8466: AND check_id in (select check_id from csc_prof_group_checks
8467: where group_id = p_group_id)
8468: And Sysdate BETWEEN Nvl(start_date_active, Sysdate)
8469: AND Nvl(end_date_active, Sysdate);
8470: ELSE

Line 8477: AND check_id in (select check_id from csc_prof_group_checks

8473: data_type, format_mask,check_upper_lower_flag,threshold_grade,
8474: check_level
8475: FROM csc_prof_checks_b
8476: WHERE check_level = 'EMPLOYEE'
8477: AND check_id in (select check_id from csc_prof_group_checks
8478: where group_id = p_group_id)
8479: And Sysdate BETWEEN Nvl(start_date_active, Sysdate)
8480: AND Nvl(end_date_active, Sysdate);
8481: END IF;