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_BLOCKS_B

Line 397: FROM csc_prof_blocks_b a

393: sql_stmnt,
394: batch_sql_stmnt,
395: currency_code,
396: select_clause
397: FROM csc_prof_blocks_b a
398: WHERE a.block_id = sel_blk_id;
399:
400: Cursor val_csr3 IS
401: Select Range_Low_Value,

Line 1010: FROM csc_prof_blocks_b b

1006: 'ACCOUNT',
1007: 'SITE' --Added 'SITE' by spamujul for ER#8473903
1008: )
1009: AND EXISTS (SELECT null
1010: FROM csc_prof_blocks_b b
1011: WHERE a.select_block_id = b.block_id
1012: AND b.batch_sql_stmnt IS NULL)
1013: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
1014: AND Nvl(end_date_active, SYSDATE);

Line 1038: FROM csc_prof_blocks_b a

1034: AND NVL(created_by_module,'XXX') <> 'SR_ONETIME';
1035: -- End fix by spamujul for NCR ER#8473903
1036: CURSOR block_csr IS
1037: SELECT block_id, sql_stmnt, currency_code
1038: FROM csc_prof_blocks_b a
1039: WHERE a.block_id = sel_blk_id;
1040:
1041: cid number;
1042: val VARCHAR2(240) := null;

Line 1496: FROM csc_prof_blocks_b a

1492: -- End fix by spamujul for ER#8473903
1493:
1494: CURSOR block_csr IS
1495: SELECT block_id, sql_stmnt, currency_code
1496: FROM csc_prof_blocks_b a
1497: WHERE a.block_id = sel_blk_id;
1498:
1499: -- added for 1850508
1500: cid number;

Line 1984: FROM csc_prof_blocks_b a

1980: CURSOR block_csr IS
1981: SELECT block_id,
1982: sql_stmnt,
1983: currency_code
1984: FROM csc_prof_blocks_b a
1985: WHERE a.block_id = p_select_block_id;
1986:
1987: /* added this condition party_id=v_party_id for Bug 1937730*/
1988: CURSOR caccount_csr IS

Line 2802: FROM csc_prof_blocks_b a

2798: CURSOR block_csr IS
2799: SELECT block_id,
2800: sql_stmnt,
2801: currency_code
2802: FROM csc_prof_blocks_b a
2803: WHERE a.block_id = sel_blk_id;
2804:
2805: /* added this condition party_id=v_party_id for Bug 1937730*/
2806: CURSOR caccount_csr IS

Line 3650: FROM csc_prof_blocks_b a

3646: sql_stmnt,
3647: UPPER(batch_sql_stmnt),
3648: currency_code,
3649: select_clause
3650: FROM csc_prof_blocks_b a
3651: WHERE a.block_id = sel_blk_id;
3652:
3653: Cursor val_csr3 IS
3654: Select Range_Low_Value,

Line 4233: FROM csc_prof_blocks_b b

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
4233: FROM csc_prof_blocks_b b
4234: WHERE a.select_block_id = b.block_id
4235: AND b.batch_sql_stmnt IS NULL)
4236: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
4237: AND Nvl(end_date_active, SYSDATE);

Line 4262: FROM csc_prof_blocks_b a

4258: -- End fix by spamujul for NCR ER#8473903
4259:
4260: CURSOR block_csr IS
4261: SELECT block_id, sql_stmnt, currency_code
4262: FROM csc_prof_blocks_b a
4263: WHERE a.block_id = sel_blk_id;
4264:
4265: cid number;
4266: val VARCHAR2(240) := null;

Line 4707: FROM csc_prof_blocks_b a

4703: AND NVL(created_by_module,'XXX') <> 'SR_ONETIME';
4704: -- End fix by spamujul for ER#8473903
4705: CURSOR block_csr IS
4706: SELECT block_id, sql_stmnt, currency_code
4707: FROM csc_prof_blocks_b a
4708: WHERE a.block_id = sel_blk_id;
4709:
4710: cid number;
4711: val VARCHAR2(240) := null;

Line 5823: FROM csc_prof_blocks_b a

5819: v_party_id Number;
5820: -- cursor to run all blocks
5821: CURSOR blocks_csr IS
5822: SELECT block_id, sql_stmnt, currency_code
5823: FROM csc_prof_blocks_b a
5824: WHERE exists ( Select b.block_id
5825: From csc_prof_check_rules_b b
5826: where b.block_id = a.block_id
5827: or b.expr_to_block_id = a.block_id)

Line 6122: FROM csc_prof_blocks_b a

6118:
6119: -- cursor to run all blocks for all checks present in that group
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'

Line 6404: FROM csc_prof_blocks_b

6400: CURSOR blocks_csr IS
6401: SELECT block_id,
6402: sql_stmnt,
6403: currency_code
6404: FROM csc_prof_blocks_b
6405: WHERE block_id = p_block_id
6406: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
6407: AND Nvl(end_date_active, Sysdate));
6408:

Line 6712: FROM csc_prof_blocks_b a

6708: CURSOR blocks_csr IS
6709: SELECT block_id,
6710: sql_stmnt,
6711: currency_code
6712: FROM csc_prof_blocks_b a
6713: WHERE exists ( Select b.block_id
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)

Line 7001: FROM csc_prof_blocks_b a

6997: CURSOR blocks_csr IS
6998: SELECT block_id,
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'

Line 7283: FROM csc_prof_blocks_b

7279: CURSOR blocks_csr(c_block_id IN NUMBER) IS
7280: SELECT block_id,
7281: sql_stmnt,
7282: currency_code
7283: FROM csc_prof_blocks_b
7284: WHERE block_id = c_block_id
7285: AND block_level in( 'CONTACT','EMPLOYEE','SITE') -- 'Included 'SITE' by spamujul for ER#8473903
7286: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
7287: AND Nvl(end_date_active, Sysdate));

Line 7477: FROM csc_prof_blocks_b a

7473: OPEN v_block_curvar FOR
7474: SELECT block_id,
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'

Line 7492: FROM csc_prof_blocks_b a

7488: OPEN v_block_curvar FOR
7489: SELECT block_id,
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)

Line 7507: FROM csc_prof_blocks_b a

7503: OPEN v_block_curvar FOR
7504: SELECT block_id,
7505: sql_stmnt,
7506: currency_code
7507: FROM csc_prof_blocks_b a
7508: WHERE exists ( Select b.block_id
7509: From csc_prof_check_rules_b b
7510: where b.block_id = a.block_id
7511: or b.expr_to_block_id = a.block_id)

Line 7522: FROM csc_prof_blocks_b a

7518: OPEN v_block_curvar FOR
7519: SELECT block_id,
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'

Line 7538: FROM csc_prof_blocks_b a

7534: OPEN v_block_curvar FOR
7535: SELECT block_id,
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)

Line 7555: FROM csc_prof_blocks_b a

7551: OPEN v_block_curvar FOR
7552: SELECT block_id,
7553: sql_stmnt,
7554: currency_code
7555: FROM csc_prof_blocks_b a
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)

Line 7761: FROM csc_prof_blocks_b a

7757: v_rec_var r_chk_rectype;
7758:
7759: CURSOR block_csr IS
7760: SELECT block_id, sql_stmnt, currency_code
7761: FROM csc_prof_blocks_b a
7762: WHERE a.block_id = sel_blk_id;
7763:
7764: CURSOR crelparty_csr IS
7765: SELECT party_id

Line 7805: FROM csc_prof_blocks_b b

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
7806: WHERE a.select_block_id = b.block_id
7807: AND b.batch_sql_stmnt IS NULL)
7808: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
7809: AND Nvl(end_date_active, SYSDATE);

Line 7858: FROM csc_prof_blocks_b b

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
7858: FROM csc_prof_blocks_b b
7859: WHERE a.select_block_id = b.block_id
7860: AND b.batch_sql_stmnt IS NULL)
7861: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
7862: AND Nvl(end_date_active, SYSDATE);

Line 8173: FROM csc_prof_blocks_b a

8169: IF p_group_id IS NULL THEN
8170: IF p_no_batch_sql = 'Y' THEN
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'

Line 8186: FROM csc_prof_blocks_b a

8182: AND block_level = 'EMPLOYEE';
8183: ELSIF p_rule_only = 'Y' THEN
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)

Line 8199: FROM csc_prof_blocks_b a

8195: AND block_level ='EMPLOYEE';
8196: ELSE
8197: OPEN v_block_curvar FOR
8198: SELECT block_id, sql_stmnt, currency_code
8199: FROM csc_prof_blocks_b a
8200: WHERE exists ( Select b.block_id
8201: From csc_prof_check_rules_b b
8202: where b.block_id = a.block_id
8203: or b.expr_to_block_id = a.block_id)

Line 8212: FROM csc_prof_blocks_b a

8208: ELSE
8209: IF p_no_batch_sql = 'Y' THEN
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'

Line 8226: FROM csc_prof_blocks_b a

8222: AND block_level = 'EMPLOYEE';
8223: ELSIF p_rule_only = 'Y' THEN
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)

Line 8241: FROM csc_prof_blocks_b a

8237: AND block_level = 'EMPLOYEE';
8238: ELSE
8239: OPEN v_block_curvar FOR
8240: SELECT block_id, sql_stmnt, currency_code
8241: FROM csc_prof_blocks_b a
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)

Line 8387: FROM csc_prof_blocks_b a

8383: v_rec_var r_chk_rectype;
8384:
8385: CURSOR block_csr IS
8386: SELECT block_id, sql_stmnt, currency_code
8387: FROM csc_prof_blocks_b a
8388: WHERE a.block_id = sel_blk_id;
8389:
8390: CURSOR employee_csr IS
8391: SELECT person_id

Line 8416: FROM csc_prof_blocks_b b

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
8417: WHERE a.select_block_id = b.block_id
8418: AND b.batch_sql_stmnt IS NULL)
8419: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
8420: AND Nvl(end_date_active, SYSDATE);

Line 8453: FROM csc_prof_blocks_b b

8449: WHERE group_id = p_group_id)
8450: AND select_type = 'B'
8451: AND check_level = 'EMPLOYEE'
8452: AND EXISTS (SELECT null
8453: FROM csc_prof_blocks_b b
8454: WHERE a.select_block_id = b.block_id
8455: AND b.batch_sql_stmnt IS NULL)
8456: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
8457: AND Nvl(end_date_active, SYSDATE);

Line 10291: csc_prof_blocks_b

10287: WHERE check_id = chk_id;
10288:
10289: cursor blk_crs is
10290: select block_level from
10291: csc_prof_blocks_b
10292: where block_id=v_blk_id;
10293:
10294: BEGIN
10295: --