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_CHECKS_B

Line 493: FROM csc_prof_checks_b

489: data_type,
490: format_mask,
491: check_upper_lower_flag,
492: threshold_grade
493: FROM csc_prof_checks_b
494: WHERE SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
495: AND Nvl(end_date_active, Sysdate)
496: AND select_type = 'B'
497: AND check_level IN ('EMPLOYEE');

Line 508: FROM csc_prof_checks_b

504: data_type,
505: format_mask,
506: check_upper_lower_flag,
507: threshold_grade
508: FROM csc_prof_checks_b
509: WHERE SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
510: AND Nvl(end_date_active, Sysdate)
511: AND select_type = 'B'
512: AND check_level IN ('PARTY',

Line 526: FROM csc_prof_checks_b

522: data_type,
523: format_mask,
524: check_upper_lower_flag,
525: threshold_grade
526: FROM csc_prof_checks_b
527: WHERE SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
528: AND Nvl(end_date_active, Sysdate)
529: AND select_type = 'B'
530: AND check_level IN ('PARTY',

Line 852: WHERE NOT EXISTS (SELECT null FROM csc_prof_checks_b b

848: results_threshold_flag,
849: rating_code,
850: color_code
851: FROM csc_prof_check_results a
852: WHERE NOT EXISTS (SELECT null FROM csc_prof_checks_b b
853: WHERE a.check_id = b.check_id
854: AND b.select_type = 'B');
855: */
856: COMMIT;

Line 1001: FROM csc_prof_checks_b a

997: CURSOR checks_csr IS
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',

Line 1455: FROM csc_prof_checks_b

1451: data_type,
1452: format_mask,
1453: check_upper_lower_flag,
1454: threshold_grade
1455: FROM csc_prof_checks_b
1456: WHERE Sysdate BETWEEN Nvl(start_date_active, Sysdate)
1457: AND Nvl(end_date_active, Sysdate)
1458: AND check_level IN ('PARTY',
1459: 'ACCOUNT'

Line 1467: FROM csc_prof_checks_b

1463: ORDER BY check_id;
1464:
1465: CURSOR checks_count IS
1466: SELECT COUNT(*)
1467: FROM csc_prof_checks_b
1468: WHERE Sysdate BETWEEN Nvl(start_date_active, Sysdate)
1469: AND Nvl(end_date_active, Sysdate)
1470: AND select_type = 'T';
1471:

Line 2375: FROM csc_prof_checks_b chk

2371: data_type,
2372: format_mask,
2373: check_upper_lower_flag,
2374: threshold_grade, check_level
2375: FROM csc_prof_checks_b chk
2376: WHERE check_level IN ('PARTY',
2377: 'ACCOUNT',
2378: 'SITE' --Added 'SITE' by spamujul for ER#8473903
2379: )

Line 2397: FROM csc_prof_checks_b chk

2393: format_mask,
2394: check_upper_lower_flag,
2395: threshold_grade,
2396: check_level
2397: FROM csc_prof_checks_b chk
2398: WHERE check_level IN ('PARTY',
2399: 'ACCOUNT',
2400: 'SITE' -- Added 'SITE' by spamujul for ER#8473903
2401: )

Line 2432: FROM csc_prof_checks_b chk

2428: format_mask,
2429: check_upper_lower_flag,
2430: threshold_grade,
2431: check_level
2432: FROM csc_prof_checks_b chk
2433: WHERE check_level IN ( 'CONTACT',
2434: 'SITE' --Added 'SITE' by spamujul for ER#8473903
2435: )
2436: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)

Line 2453: FROM csc_prof_checks_b chk

2449: format_mask,
2450: check_upper_lower_flag,
2451: threshold_grade,
2452: check_level
2453: FROM csc_prof_checks_b chk
2454: WHERE check_level IN ( 'CONTACT',
2455: 'SITE' --Added 'SITE' by spamujul for ER#8473903
2456: )
2457: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)

Line 2475: FROM csc_prof_checks_b chk

2471: format_mask,
2472: check_upper_lower_flag,
2473: threshold_grade,
2474: check_level
2475: FROM csc_prof_checks_b chk
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

Line 2493: FROM csc_prof_checks_b chk

2489: format_mask,
2490: check_upper_lower_flag,
2491: threshold_grade,
2492: check_level
2493: FROM csc_prof_checks_b chk
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

Line 2753: FROM csc_prof_checks_b chk

2749: format_mask,
2750: check_upper_lower_flag,
2751: threshold_grade,
2752: check_level
2753: FROM csc_prof_checks_b chk
2754: WHERE check_level IN ('PARTY',
2755: 'ACCOUNT', -- Added 'SITE' by spamujul for ER#8473903
2756: 'SITE'
2757: )

Line 2776: FROM csc_prof_checks_b chk

2772: format_mask,
2773: check_upper_lower_flag,
2774: threshold_grade,
2775: check_level
2776: FROM csc_prof_checks_b chk
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

Line 2828: FROM csc_prof_checks_b chk

2824: format_mask,
2825: check_upper_lower_flag,
2826: threshold_grade,
2827: check_level
2828: FROM csc_prof_checks_b chk
2829: WHERE check_level IN ( 'CONTACT',
2830: 'SITE' -- Added'SITE' by spamujul for ER#8473903
2831: )
2832: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)

Line 3742: FROM csc_prof_checks_b

3738: data_type,
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)

Line 3759: FROM csc_prof_checks_b

3755: data_type,
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)

Line 3776: FROM csc_prof_checks_b

3772: data_type,
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)

Line 4067: AND EXISTS (SELECT 1 FROM csc_prof_checks_b b

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;
4070: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
4071:

Line 4226: FROM csc_prof_checks_b a

4222: format_mask,
4223: check_upper_lower_flag,
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'

Line 4668: FROM csc_prof_checks_b

4664: format_mask,
4665: check_upper_lower_flag,
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

Line 4678: FROM csc_prof_checks_b

4674: AND Nvl(end_date_active, Sysdate)
4675: AND select_type = 'T';
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)

Line 6124: FROM csc_prof_checks_b b

6120: CURSOR blocks_csr IS
6121: SELECT block_id, sql_stmnt, currency_code
6122: FROM csc_prof_blocks_b a
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)

Line 7003: FROM csc_prof_checks_b b

6999: sql_stmnt,
7000: currency_code
7001: FROM csc_prof_blocks_b a
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))

Line 7479: FROM csc_prof_checks_b b

7475: sql_stmnt,
7476: currency_code
7477: FROM csc_prof_blocks_b a
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)

Line 7494: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

7490: sql_stmnt,
7491: currency_code
7492: FROM csc_prof_blocks_b a
7493: WHERE exists ( SELECT b.block_id
7494: FROM csc_prof_check_rules_b b, csc_prof_checks_b c
7495: WHERE (b.block_id = a.block_id
7496: or b.expr_to_block_id = a.block_id)
7497: AND c.select_type = 'T'
7498: AND b.check_id = c.check_id)

Line 7524: FROM csc_prof_checks_b b

7520: sql_stmnt,
7521: currency_code
7522: FROM csc_prof_blocks_b a
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))

Line 7540: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

7536: sql_stmnt,
7537: currency_code
7538: FROM csc_prof_blocks_b a
7539: WHERE EXISTS ( SELECT b.block_id
7540: FROM csc_prof_check_rules_b b, csc_prof_checks_b c
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

Line 7799: FROM csc_prof_checks_b a

7795: data_type,
7796: format_mask,
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

Line 7820: FROM csc_prof_checks_b

7816: format_mask,
7817: check_upper_lower_flag,
7818: threshold_grade,
7819: check_level
7820: FROM csc_prof_checks_b
7821: WHERE check_level IN ( 'CONTACT','SITE') -- Included by spamujul for ER#8473903
7822: AND select_type = 'T'
7823: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
7824: AND Nvl(end_date_active, Sysdate);

Line 7835: FROM csc_prof_checks_b

7831: format_mask,
7832: check_upper_lower_flag,
7833: threshold_grade,
7834: check_level
7835: FROM csc_prof_checks_b
7836: WHERE check_level IN ( 'CONTACT','SITE') -- Included by spamujul for ER#8473903
7837: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
7838: AND Nvl(end_date_active, Sysdate);
7839: END IF;

Line 7851: FROM csc_prof_checks_b a

7847: format_mask,
7848: check_upper_lower_flag,
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'

Line 7873: FROM csc_prof_checks_b

7869: format_mask,
7870: check_upper_lower_flag,
7871: threshold_grade,
7872: check_level
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

Line 7891: FROM csc_prof_checks_b

7887: format_mask,
7888: check_upper_lower_flag,
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)

Line 8175: FROM csc_prof_checks_b b

8171: OPEN v_block_curvar FOR
8172: SELECT block_id, sql_stmnt, currency_code
8173: FROM csc_prof_blocks_b a
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)

Line 8188: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

8184: OPEN v_block_curvar FOR
8185: SELECT block_id, sql_stmnt, currency_code
8186: FROM csc_prof_blocks_b a
8187: WHERE exists ( SELECT b.block_id
8188: FROM csc_prof_check_rules_b b, csc_prof_checks_b c
8189: WHERE (b.block_id = a.block_id
8190: or b.expr_to_block_id = a.block_id)
8191: AND c.select_type = 'T'
8192: AND b.check_id = c.check_id)

Line 8214: FROM csc_prof_checks_b b

8210: OPEN v_block_curvar FOR
8211: SELECT block_id, sql_stmnt, currency_code
8212: FROM csc_prof_blocks_b a
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))

Line 8228: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

8224: OPEN v_block_curvar FOR
8225: SELECT block_id, sql_stmnt, currency_code
8226: FROM csc_prof_blocks_b a
8227: WHERE EXISTS ( SELECT b.block_id
8228: FROM csc_prof_check_rules_b b, csc_prof_checks_b c
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

Line 8411: FROM csc_prof_checks_b a

8407: OPEN v_checks_curvar FOR
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

Line 8426: FROM csc_prof_checks_b

8422: OPEN v_checks_curvar FOR
8423: SELECT check_id, select_type, select_block_id,
8424: data_type, format_mask,check_upper_lower_flag,threshold_grade,
8425: check_level
8426: FROM csc_prof_checks_b
8427: WHERE check_level ='EMPLOYEE'
8428: AND select_type = 'T'
8429: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
8430: AND Nvl(end_date_active, Sysdate);

Line 8436: FROM csc_prof_checks_b

8432: OPEN v_checks_curvar FOR
8433: SELECT check_id, select_type, select_block_id,
8434: data_type, format_mask,check_upper_lower_flag,threshold_grade,
8435: check_level
8436: FROM csc_prof_checks_b
8437: WHERE check_level ='EMPLOYEE'
8438: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
8439: AND Nvl(end_date_active, Sysdate);
8440: END IF;

Line 8447: FROM csc_prof_checks_b a

8443: OPEN v_checks_curvar FOR
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'

Line 8463: FROM csc_prof_checks_b

8459: OPEN v_checks_curvar FOR
8460: SELECT check_id, select_type, select_block_id,
8461: data_type, format_mask,check_upper_lower_flag,threshold_grade,
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)

Line 8475: FROM csc_prof_checks_b

8471: OPEN v_checks_curvar FOR
8472: SELECT check_id, select_type, select_block_id,
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)