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 835: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks)

831: SELECT check_id, select_type, select_block_id,
832: data_type, format_mask,check_upper_lower_flag,
833: threshold_grade, check_level
834: FROM csc_prof_checks_b a
835: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks)
836: AND select_type = 'B'
837: AND check_level IN ('PARTY', 'ACCOUNT')
838: AND EXISTS (SELECT null
839: FROM csc_prof_blocks_b b

Line 1709: FROM csc_prof_group_checks a

1705: WHERE check_level IN ('PARTY','ACCOUNT')
1706: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
1707: AND nvl(end_date_active, Sysdate))
1708: AND EXISTS ( SELECT a.check_id
1709: FROM csc_prof_group_checks a
1710: WHERE a.group_id = p_group_id
1711: AND chk.check_id = a.check_id);
1712:
1713: /* added cursor checks_crit_csr for JIT enhancement -- Bug 4535407 */

Line 1722: FROM csc_prof_group_checks a

1718: WHERE check_level IN ('PARTY','ACCOUNT')
1719: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
1720: AND nvl(end_date_active, Sysdate))
1721: AND EXISTS ( SELECT a.check_id
1722: FROM csc_prof_group_checks a
1723: WHERE a.group_id = p_group_id
1724: AND chk.check_id = a.check_id
1725: AND a.critical_flag = 'Y');
1726:

Line 1748: FROM csc_prof_group_checks a

1744: WHERE check_level = 'CONTACT'
1745: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
1746: AND nvl(end_date_active, Sysdate))
1747: AND EXISTS ( SELECT a.check_id
1748: FROM csc_prof_group_checks a
1749: WHERE a.group_id = p_group_id
1750: AND chk.check_id = a.check_id);
1751:
1752: /* added cursor checks_csr_jit for JIT enhancement -- Bug 4535407 */

Line 1761: FROM csc_prof_group_checks a

1757: WHERE check_level = 'CONTACT'
1758: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
1759: AND nvl(end_date_active, Sysdate))
1760: AND EXISTS ( SELECT a.check_id
1761: FROM csc_prof_group_checks a
1762: WHERE a.group_id = p_group_id
1763: AND chk.check_id = a.check_id
1764: AND a.critical_flag = 'Y');
1765:

Line 1775: FROM csc_prof_group_checks a

1771: WHERE check_level = 'EMPLOYEE'
1772: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
1773: AND nvl(end_date_active, Sysdate))
1774: AND EXISTS ( SELECT a.check_id
1775: FROM csc_prof_group_checks a
1776: WHERE a.group_id = p_group_id
1777: AND chk.check_id = a.check_id);
1778:
1779: CURSOR emp_checks_crit_csr IS

Line 1787: FROM csc_prof_group_checks a

1783: WHERE check_level = 'EMPLOYEE'
1784: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
1785: AND nvl(end_date_active, Sysdate))
1786: AND EXISTS ( SELECT a.check_id
1787: FROM csc_prof_group_checks a
1788: WHERE a.group_id = p_group_id
1789: AND chk.check_id = a.check_id
1790: AND a.critical_flag = 'Y');
1791:

Line 2047: FROM csc_prof_group_checks a

2043: WHERE check_level IN ('PARTY','ACCOUNT')
2044: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2045: AND nvl(end_date_active, Sysdate))
2046: AND Exists ( SELECT a.check_id
2047: FROM csc_prof_group_checks a
2048: WHERE chk.check_id = a.check_id
2049: AND sysdate between
2050: nvl(a.start_date_active,sysdate)
2051: AND nvl(a.end_date_active,sysdate));

Line 2063: FROM csc_prof_group_checks a

2059: WHERE check_level IN ('EMPLOYEE')
2060: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2061: AND nvl(end_date_active, Sysdate))
2062: AND Exists ( SELECT a.check_id
2063: FROM csc_prof_group_checks a
2064: WHERE chk.check_id = a.check_id
2065: AND sysdate between
2066: nvl(a.start_date_active,sysdate)
2067: AND nvl(a.end_date_active,sysdate));

Line 2100: FROM csc_prof_group_checks a

2096: WHERE check_level = 'CONTACT'
2097: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
2098: AND nvl(end_date_active, Sysdate))
2099: AND Exists ( SELECT a.check_id
2100: FROM csc_prof_group_checks a
2101: WHERE chk.check_id = a.check_id
2102: AND sysdate between nvl(a.start_date_active,sysdate)
2103: AND nvl(a.end_date_active,sysdate));
2104:

Line 2649: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

2645: OPEN checks_csr FOR
2646: SELECT check_id, select_block_id, check_level,
2647: data_type, format_mask, check_upper_lower_flag, threshold_grade
2648: FROM csc_prof_checks_b
2649: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
2650: WHERE group_id = p_group_id)
2651: AND SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
2652: AND Nvl(end_date_active, Sysdate)
2653: AND select_type = 'B'

Line 2662: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

2658: OPEN checks_csr FOR
2659: SELECT check_id, select_block_id,check_level,
2660: data_type, format_mask, check_upper_lower_flag, threshold_grade
2661: FROM csc_prof_checks_b
2662: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
2663: WHERE group_id = p_group_id)
2664: AND SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
2665: AND Nvl(end_date_active, Sysdate)
2666: AND select_type = 'B'

Line 2673: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

2669: OPEN checks_csr FOR
2670: SELECT check_id, select_block_id,check_level,
2671: data_type, format_mask, check_upper_lower_flag, threshold_grade
2672: FROM csc_prof_checks_b
2673: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
2674: WHERE group_id = p_group_id)
2675: AND SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
2676: AND Nvl(end_date_active, Sysdate)
2677: AND select_type = 'B'

Line 2888: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

2884: value, currency_code, grade, created_by, creation_date,
2885: last_updated_by, last_update_date, last_update_login,
2886: results_threshold_flag, rating_code, color_code
2887: FROM csc_prof_check_results
2888: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
2889: MINUS
2890: SELECT check_id FROM csc_prof_group_checks a
2891: WHERE group_id = p_group_id
2892: AND EXISTS (SELECT 1 FROM csc_prof_checks_b b

Line 2890: SELECT check_id FROM csc_prof_group_checks a

2886: results_threshold_flag, rating_code, color_code
2887: FROM csc_prof_check_results
2888: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
2889: MINUS
2890: SELECT check_id FROM csc_prof_group_checks a
2891: WHERE group_id = p_group_id
2892: AND EXISTS (SELECT 1 FROM csc_prof_checks_b b
2893: WHERE a.check_id = b.check_id AND b.select_type = 'B'));
2894:

Line 3027: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

3023: SELECT check_id, select_type, select_block_id,
3024: data_type, format_mask,check_upper_lower_flag,
3025: threshold_grade, check_level
3026: FROM csc_prof_checks_b a
3027: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
3028: WHERE group_id = p_group_id)
3029: AND select_type = 'B'
3030: AND check_level IN ('PARTY','ACCOUNT')
3031: AND EXISTS (SELECT null

Line 3337: WHERE check_id in (select check_id from csc_prof_group_checks

3333: SELECT check_id, select_type, select_block_id,
3334: data_type, format_mask,check_upper_lower_flag,threshold_grade,
3335: check_level
3336: FROM csc_prof_checks_b
3337: WHERE check_id in (select check_id from csc_prof_group_checks
3338: where group_id = p_group_id)
3339: AND check_level IN ('PARTY','ACCOUNT')
3340: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
3341: AND Nvl(end_date_active, Sysdate)

Line 3347: WHERE check_id in (select check_id from csc_prof_group_checks

3343:
3344: CURSOR checks_count IS
3345: SELECT COUNT(*)
3346: FROM csc_prof_checks_b
3347: WHERE check_id in (select check_id from csc_prof_group_checks
3348: where group_id = p_group_id)
3349: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
3350: AND Nvl(end_date_active, Sysdate)
3351: AND select_type = 'T';

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

4422: WHERE EXISTS ( SELECT null
4423: FROM csc_prof_checks_b b
4424: WHERE b.select_block_id = a.block_id
4425: AND b.select_type = 'B'
4426: AND check_id IN (SELECT check_id FROM csc_prof_group_checks))
4427: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
4428: AND Nvl(end_date_active, SYSDATE)
4429: AND batch_sql_stmnt IS NULL;
4430:

Line 4792: And check_id in (Select check_id from csc_prof_group_checks

4788: WHERE exists ( Select b.block_id
4789: From csc_prof_check_rules_b b
4790: where (b.block_id = a.block_id
4791: or b.expr_to_block_id = a.block_id)
4792: And check_id in (Select check_id from csc_prof_group_checks
4793: where group_id = p_group_id))
4794: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
4795: AND Nvl(end_date_active, Sysdate)
4796: AND block_level IN ('PARTY','ACCOUNT');

Line 4997: AND check_id IN (SELECT check_id FROM csc_prof_group_checks

4993: WHERE EXISTS ( SELECT null
4994: FROM csc_prof_checks_b b
4995: WHERE b.select_block_id = a.block_id
4996: AND b.select_type = 'B'
4997: AND check_id IN (SELECT check_id FROM csc_prof_group_checks
4998: WHERE group_id = p_group_id))
4999: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
5000: AND Nvl(end_date_active, SYSDATE)
5001: AND batch_sql_stmnt IS NULL;

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

5256: WHERE EXISTS ( SELECT null
5257: FROM csc_prof_checks_b b
5258: WHERE b.select_block_id = a.block_id
5259: AND b.select_type = 'B'
5260: AND check_id IN (SELECT check_id FROM csc_prof_group_checks))
5261: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
5262: AND Nvl(end_date_active, SYSDATE)
5263: AND batch_sql_stmnt IS NULL
5264: AND block_level = 'CONTACT';

Line 5299: AND check_id IN (SELECT check_id FROM csc_prof_group_checks

5295: WHERE EXISTS ( SELECT null
5296: FROM csc_prof_checks_b b
5297: WHERE b.select_block_id = a.block_id
5298: AND b.select_type = 'B'
5299: AND check_id IN (SELECT check_id FROM csc_prof_group_checks
5300: WHERE group_id = p_group_id))
5301: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
5302: AND Nvl(end_date_active, SYSDATE)
5303: AND batch_sql_stmnt IS NULL

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

5311: WHERE (b.block_id = a.block_id
5312: OR b.expr_to_block_id = a.block_id)
5313: AND c.select_type = 'T'
5314: AND b.check_id = c.check_id
5315: AND b.check_id IN (SELECT check_id from csc_prof_group_checks
5316: WHERE group_id = p_group_id))
5317: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5318: AND Nvl(end_date_active, Sysdate)
5319: AND block_level = 'CONTACT';

Line 5328: AND check_id IN (Select check_id from csc_prof_group_checks

5324: WHERE EXISTS ( SELECT b.block_id
5325: FROM csc_prof_check_rules_b b
5326: WHERE (b.block_id = a.block_id
5327: or b.expr_to_block_id = a.block_id)
5328: AND check_id IN (Select check_id from csc_prof_group_checks
5329: where group_id = p_group_id))
5330: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5331: AND Nvl(end_date_active, Sysdate)
5332: AND block_level ='CONTACT';

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

5476: SELECT check_id, select_type, select_block_id,
5477: data_type, format_mask, check_upper_lower_flag,
5478: threshold_grade, check_level
5479: FROM csc_prof_checks_b a
5480: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks)
5481: AND select_type = 'B'
5482: AND check_level = 'CONTACT'
5483: AND EXISTS (SELECT null
5484: FROM csc_prof_blocks_b b

Line 5516: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

5512: SELECT check_id, select_type, select_block_id,
5513: data_type, format_mask,check_upper_lower_flag,
5514: threshold_grade, check_level
5515: FROM csc_prof_checks_b a
5516: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
5517: WHERE group_id = p_group_id)
5518: AND select_type = 'B'
5519: AND check_level = 'CONTACT'
5520: AND EXISTS (SELECT null

Line 5534: AND check_id in (select check_id from csc_prof_group_checks

5530: check_level
5531: FROM csc_prof_checks_b
5532: WHERE check_level = 'CONTACT'
5533: AND select_type = 'T'
5534: AND check_id in (select check_id from csc_prof_group_checks
5535: where group_id = p_group_id)
5536: And Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5537: AND Nvl(end_date_active, Sysdate);
5538: ELSE

Line 5545: AND check_id in (select check_id from csc_prof_group_checks

5541: data_type, format_mask,check_upper_lower_flag,threshold_grade,
5542: check_level
5543: FROM csc_prof_checks_b
5544: WHERE check_level = 'CONTACT'
5545: AND check_id in (select check_id from csc_prof_group_checks
5546: where group_id = p_group_id)
5547: And Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5548: AND Nvl(end_date_active, Sysdate);
5549: END IF;

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

5716: WHERE EXISTS ( SELECT null
5717: FROM csc_prof_checks_b b
5718: WHERE b.select_block_id = a.block_id
5719: AND b.select_type = 'B'
5720: AND check_id IN (SELECT check_id FROM csc_prof_group_checks))
5721: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
5722: AND Nvl(end_date_active, SYSDATE)
5723: AND batch_sql_stmnt IS NULL
5724: AND block_level = 'EMPLOYEE';

Line 5759: AND check_id IN (SELECT check_id FROM csc_prof_group_checks

5755: WHERE EXISTS ( SELECT null
5756: FROM csc_prof_checks_b b
5757: WHERE b.select_block_id = a.block_id
5758: AND b.select_type = 'B'
5759: AND check_id IN (SELECT check_id FROM csc_prof_group_checks
5760: WHERE group_id = p_group_id))
5761: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
5762: AND Nvl(end_date_active, SYSDATE)
5763: AND batch_sql_stmnt IS NULL

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

5771: WHERE (b.block_id = a.block_id
5772: OR b.expr_to_block_id = a.block_id)
5773: AND c.select_type = 'T'
5774: AND b.check_id = c.check_id
5775: AND b.check_id IN (SELECT check_id from csc_prof_group_checks
5776: WHERE group_id = p_group_id))
5777: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5778: AND Nvl(end_date_active, Sysdate)
5779: AND block_level = 'EMPLOYEE';

Line 5788: AND check_id IN (Select check_id from csc_prof_group_checks

5784: WHERE EXISTS ( SELECT b.block_id
5785: FROM csc_prof_check_rules_b b
5786: WHERE (b.block_id = a.block_id
5787: or b.expr_to_block_id = a.block_id)
5788: AND check_id IN (Select check_id from csc_prof_group_checks
5789: where group_id = p_group_id))
5790: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5791: AND Nvl(end_date_active, Sysdate)
5792: AND block_level ='EMPLOYEE';

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

5936: SELECT check_id, select_type, select_block_id,
5937: data_type, format_mask, check_upper_lower_flag,
5938: threshold_grade, check_level
5939: FROM csc_prof_checks_b a
5940: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks)
5941: AND select_type = 'B'
5942: AND check_level = 'EMPLOYEE'
5943: AND EXISTS (SELECT null
5944: FROM csc_prof_blocks_b b

Line 5976: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks

5972: SELECT check_id, select_type, select_block_id,
5973: data_type, format_mask,check_upper_lower_flag,
5974: threshold_grade, check_level
5975: FROM csc_prof_checks_b a
5976: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
5977: WHERE group_id = p_group_id)
5978: AND select_type = 'B'
5979: AND check_level = 'EMPLOYEE'
5980: AND EXISTS (SELECT null

Line 5994: AND check_id in (select check_id from csc_prof_group_checks

5990: check_level
5991: FROM csc_prof_checks_b
5992: WHERE check_level = 'EMPLOYEE'
5993: AND select_type = 'T'
5994: AND check_id in (select check_id from csc_prof_group_checks
5995: where group_id = p_group_id)
5996: And Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5997: AND Nvl(end_date_active, Sysdate);
5998: ELSE

Line 6005: AND check_id in (select check_id from csc_prof_group_checks

6001: data_type, format_mask,check_upper_lower_flag,threshold_grade,
6002: check_level
6003: FROM csc_prof_checks_b
6004: WHERE check_level = 'EMPLOYEE'
6005: AND check_id in (select check_id from csc_prof_group_checks
6006: where group_id = p_group_id)
6007: And Sysdate BETWEEN Nvl(start_date_active, Sysdate)
6008: AND Nvl(end_date_active, Sysdate);
6009: END IF;