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 472: FROM csc_prof_checks_b

468:
469: OPEN checks_csr FOR
470: SELECT check_id, select_block_id, check_level,
471: data_type, format_mask, check_upper_lower_flag, threshold_grade
472: FROM csc_prof_checks_b
473: WHERE SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
474: AND Nvl(end_date_active, Sysdate)
475: AND select_type = 'B'
476: AND check_level IN ('EMPLOYEE');

Line 482: FROM csc_prof_checks_b

478: IF g_dashboard_for_contact = 'Y' THEN
479: OPEN checks_csr FOR
480: SELECT check_id, select_block_id,check_level,
481: data_type, format_mask, check_upper_lower_flag, threshold_grade
482: FROM csc_prof_checks_b
483: WHERE SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
484: AND Nvl(end_date_active, Sysdate)
485: AND select_type = 'B'
486: AND check_level IN ('PARTY', 'ACCOUNT', 'CONTACT');

Line 491: FROM csc_prof_checks_b

487: ELSIF g_dashboard_for_contact = 'N' THEN
488: OPEN checks_csr FOR
489: SELECT check_id, select_block_id,check_level,
490: data_type, format_mask, check_upper_lower_flag, threshold_grade
491: FROM csc_prof_checks_b
492: WHERE SYSDATE BETWEEN Nvl(start_date_active, Sysdate)
493: AND Nvl(end_date_active, Sysdate)
494: AND select_type = 'B'
495: AND check_level IN ('PARTY', 'ACCOUNT');

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

703: value, currency_code, grade, created_by, creation_date,
704: last_updated_by, last_update_date, last_update_login,
705: results_threshold_flag, rating_code, color_code
706: FROM csc_prof_check_results a
707: WHERE NOT EXISTS (SELECT null FROM csc_prof_checks_b b
708: WHERE a.check_id = b.check_id
709: AND b.select_type = 'B');
710:
711: COMMIT;

Line 834: FROM csc_prof_checks_b a

830: CURSOR checks_csr IS
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

Line 1140: FROM csc_prof_checks_b

1136:
1137: CURSOR checks_csr IS
1138: SELECT check_id, select_type, select_block_id,check_level,
1139: data_type, format_mask,check_upper_lower_flag,threshold_grade
1140: FROM csc_prof_checks_b
1141: WHERE Sysdate BETWEEN Nvl(start_date_active, Sysdate)
1142: AND Nvl(end_date_active, Sysdate)
1143: AND check_level IN ('PARTY', 'ACCOUNT')
1144: AND select_type = 'T'

Line 1149: FROM csc_prof_checks_b

1145: ORDER BY check_id;
1146:
1147: CURSOR checks_count IS
1148: SELECT COUNT(*)
1149: FROM csc_prof_checks_b
1150: WHERE Sysdate BETWEEN Nvl(start_date_active, Sysdate)
1151: AND Nvl(end_date_active, Sysdate)
1152: AND select_type = 'T';
1153:

Line 1704: FROM csc_prof_checks_b chk

1700:
1701: CURSOR checks_csr IS
1702: SELECT check_id, select_type, select_block_id, data_type, format_mask,
1703: check_upper_lower_flag, threshold_grade, check_level
1704: FROM csc_prof_checks_b chk
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

Line 1717: FROM csc_prof_checks_b chk

1713: /* added cursor checks_crit_csr for JIT enhancement -- Bug 4535407 */
1714: CURSOR checks_crit_csr IS
1715: SELECT check_id, select_type, select_block_id, data_type, format_mask,
1716: check_upper_lower_flag, threshold_grade, check_level
1717: FROM csc_prof_checks_b chk
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

Line 1743: FROM csc_prof_checks_b chk

1739:
1740: CURSOR rel_checks_csr IS
1741: SELECT check_id, select_type, select_block_id, data_type, format_mask,
1742: check_upper_lower_flag, threshold_grade, check_level
1743: FROM csc_prof_checks_b chk
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

Line 1756: FROM csc_prof_checks_b chk

1752: /* added cursor checks_csr_jit for JIT enhancement -- Bug 4535407 */
1753: CURSOR rel_checks_crit_csr IS
1754: SELECT check_id, select_type, select_block_id, data_type, format_mask,
1755: check_upper_lower_flag, threshold_grade, check_level
1756: FROM csc_prof_checks_b chk
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

Line 1770: FROM csc_prof_checks_b chk

1766: /* R12 Employee HelpDesk Modifications */
1767: CURSOR emp_checks_csr IS
1768: SELECT check_id, select_type, select_block_id, data_type, format_mask,
1769: check_upper_lower_flag, threshold_grade, check_level
1770: FROM csc_prof_checks_b chk
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

Line 1782: FROM csc_prof_checks_b chk

1778:
1779: CURSOR emp_checks_crit_csr IS
1780: SELECT check_id, select_type, select_block_id, data_type, format_mask,
1781: check_upper_lower_flag, threshold_grade, check_level
1782: FROM csc_prof_checks_b chk
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

Line 2042: FROM csc_prof_checks_b chk

2038: CURSOR checks_csr IS
2039: SELECT check_id, select_type, select_block_id, data_type,
2040: format_mask,check_upper_lower_flag,threshold_grade,
2041: check_level
2042: FROM csc_prof_checks_b chk
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

Line 2058: FROM csc_prof_checks_b chk

2054: CURSOR checks_emp_csr IS
2055: SELECT check_id, select_type, select_block_id, data_type,
2056: format_mask,check_upper_lower_flag,threshold_grade,
2057: check_level
2058: FROM csc_prof_checks_b chk
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

Line 2095: FROM csc_prof_checks_b chk

2091:
2092: CURSOR checks_relparty_csr IS
2093: SELECT check_id, select_type, select_block_id, data_type, format_mask,
2094: check_upper_lower_flag,threshold_grade,check_level
2095: FROM csc_prof_checks_b chk
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

Line 2648: FROM csc_prof_checks_b

2644: IF g_dashboard_for_employee ='Y' THEN
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)

Line 2661: FROM csc_prof_checks_b

2657: IF g_dashboard_for_contact = 'Y' THEN
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)

Line 2672: FROM csc_prof_checks_b

2668: ELSIF g_dashboard_for_contact = 'N' THEN
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)

Line 2892: AND EXISTS (SELECT 1 FROM csc_prof_checks_b b

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:
2895: COMMIT;
2896:

Line 3026: FROM csc_prof_checks_b a

3022: CURSOR checks_csr IS
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')

Line 3336: FROM csc_prof_checks_b

3332: CURSOR checks_csr IS
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)

Line 3346: FROM csc_prof_checks_b

3342: AND select_type = 'T';
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)

Line 4423: FROM csc_prof_checks_b b

4419: CURSOR blocks_csr IS
4420: SELECT block_id, sql_stmnt, currency_code
4421: FROM csc_prof_blocks_b a
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)

Line 4994: FROM csc_prof_checks_b b

4990: CURSOR blocks_csr IS
4991: SELECT block_id, sql_stmnt, currency_code
4992: FROM csc_prof_blocks_b a
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))

Line 5257: FROM csc_prof_checks_b b

5253: OPEN v_block_curvar FOR
5254: SELECT block_id, sql_stmnt, currency_code
5255: FROM csc_prof_blocks_b a
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)

Line 5270: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

5266: OPEN v_block_curvar FOR
5267: SELECT block_id, sql_stmnt, currency_code
5268: FROM csc_prof_blocks_b a
5269: WHERE exists ( SELECT b.block_id
5270: FROM csc_prof_check_rules_b b, csc_prof_checks_b c
5271: WHERE (b.block_id = a.block_id
5272: or b.expr_to_block_id = a.block_id)
5273: AND c.select_type = 'T'
5274: AND b.check_id = c.check_id)

Line 5296: FROM csc_prof_checks_b b

5292: OPEN v_block_curvar FOR
5293: SELECT block_id, sql_stmnt, currency_code
5294: FROM csc_prof_blocks_b a
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))

Line 5310: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

5306: OPEN v_block_curvar FOR
5307: SELECT block_id, sql_stmnt, currency_code
5308: FROM csc_prof_blocks_b a
5309: WHERE EXISTS ( SELECT b.block_id
5310: FROM csc_prof_check_rules_b b, csc_prof_checks_b c
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

Line 5479: FROM csc_prof_checks_b a

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

Line 5494: FROM csc_prof_checks_b

5490: OPEN v_checks_curvar FOR
5491: SELECT check_id, select_type, select_block_id,
5492: data_type, format_mask,check_upper_lower_flag,threshold_grade,
5493: check_level
5494: FROM csc_prof_checks_b
5495: WHERE check_level ='CONTACT'
5496: AND select_type = 'T'
5497: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5498: AND Nvl(end_date_active, Sysdate);

Line 5504: FROM csc_prof_checks_b

5500: OPEN v_checks_curvar FOR
5501: SELECT check_id, select_type, select_block_id,
5502: data_type, format_mask,check_upper_lower_flag,threshold_grade,
5503: check_level
5504: FROM csc_prof_checks_b
5505: WHERE check_level ='CONTACT'
5506: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5507: AND Nvl(end_date_active, Sysdate);
5508: END IF;

Line 5515: FROM csc_prof_checks_b a

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

Line 5531: FROM csc_prof_checks_b

5527: OPEN v_checks_curvar FOR
5528: SELECT check_id, select_type, select_block_id,
5529: data_type, format_mask,check_upper_lower_flag,threshold_grade,
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)

Line 5543: FROM csc_prof_checks_b

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

Line 5717: FROM csc_prof_checks_b b

5713: OPEN v_block_curvar FOR
5714: SELECT block_id, sql_stmnt, currency_code
5715: FROM csc_prof_blocks_b a
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)

Line 5730: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

5726: OPEN v_block_curvar FOR
5727: SELECT block_id, sql_stmnt, currency_code
5728: FROM csc_prof_blocks_b a
5729: WHERE exists ( SELECT b.block_id
5730: FROM csc_prof_check_rules_b b, csc_prof_checks_b c
5731: WHERE (b.block_id = a.block_id
5732: or b.expr_to_block_id = a.block_id)
5733: AND c.select_type = 'T'
5734: AND b.check_id = c.check_id)

Line 5756: FROM csc_prof_checks_b b

5752: OPEN v_block_curvar FOR
5753: SELECT block_id, sql_stmnt, currency_code
5754: FROM csc_prof_blocks_b a
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))

Line 5770: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

5766: OPEN v_block_curvar FOR
5767: SELECT block_id, sql_stmnt, currency_code
5768: FROM csc_prof_blocks_b a
5769: WHERE EXISTS ( SELECT b.block_id
5770: FROM csc_prof_check_rules_b b, csc_prof_checks_b c
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

Line 5939: FROM csc_prof_checks_b a

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

Line 5954: FROM csc_prof_checks_b

5950: OPEN v_checks_curvar FOR
5951: SELECT check_id, select_type, select_block_id,
5952: data_type, format_mask,check_upper_lower_flag,threshold_grade,
5953: check_level
5954: FROM csc_prof_checks_b
5955: WHERE check_level ='EMPLOYEE'
5956: AND select_type = 'T'
5957: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5958: AND Nvl(end_date_active, Sysdate);

Line 5964: FROM csc_prof_checks_b

5960: OPEN v_checks_curvar FOR
5961: SELECT check_id, select_type, select_block_id,
5962: data_type, format_mask,check_upper_lower_flag,threshold_grade,
5963: check_level
5964: FROM csc_prof_checks_b
5965: WHERE check_level ='EMPLOYEE'
5966: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5967: AND Nvl(end_date_active, Sysdate);
5968: END IF;

Line 5975: FROM csc_prof_checks_b a

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

Line 5991: FROM csc_prof_checks_b

5987: OPEN v_checks_curvar FOR
5988: SELECT check_id, select_type, select_block_id,
5989: data_type, format_mask,check_upper_lower_flag,threshold_grade,
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)

Line 6003: FROM csc_prof_checks_b

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