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 399: FROM csc_prof_blocks_b a

395: checks_csr checks_cur_var;
396:
397: CURSOR block_csr IS
398: SELECT block_id, sql_stmnt, batch_sql_stmnt, currency_code, select_clause
399: FROM csc_prof_blocks_b a
400: WHERE a.block_id = sel_blk_id;
401:
402: Cursor val_csr3 IS
403: Select Range_Low_Value, Range_High_Value

Line 839: FROM csc_prof_blocks_b b

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
840: WHERE a.select_block_id = b.block_id
841: AND b.batch_sql_stmnt IS NULL)
842: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
843: AND Nvl(end_date_active, SYSDATE);

Line 860: FROM csc_prof_blocks_b a

856: AND status = 'A' ;
857:
858: CURSOR block_csr IS
859: SELECT block_id, sql_stmnt, currency_code
860: FROM csc_prof_blocks_b a
861: WHERE a.block_id = sel_blk_id;
862:
863: cid number;
864: val VARCHAR2(240) := null;

Line 1170: FROM csc_prof_blocks_b a

1166: AND status = 'A';
1167:
1168: CURSOR block_csr IS
1169: SELECT block_id, sql_stmnt, currency_code
1170: FROM csc_prof_blocks_b a
1171: WHERE a.block_id = sel_blk_id;
1172:
1173: -- Added for 1850508
1174: cid number;

Line 1520: FROM csc_prof_blocks_b a

1516: WHERE check_id = chk_id);
1517:
1518: CURSOR block_csr IS
1519: SELECT block_id, sql_stmnt, currency_code
1520: FROM csc_prof_blocks_b a
1521: WHERE a.block_id = p_select_block_id;
1522:
1523: /* added this condition party_id=v_party_id for Bug 1937730*/
1524: CURSOR caccount_csr IS

Line 2082: FROM csc_prof_blocks_b a

2078: Where check_id = chk_id);
2079:
2080: CURSOR block_csr IS
2081: SELECT block_id, sql_stmnt, currency_code
2082: FROM csc_prof_blocks_b a
2083: WHERE a.block_id = sel_blk_id;
2084:
2085: /* added this condition party_id=v_party_id for Bug 1937730*/
2086: CURSOR caccount_csr IS

Line 2579: FROM csc_prof_blocks_b a

2575: checks_csr checks_cur_var;
2576:
2577: CURSOR block_csr IS
2578: SELECT block_id, sql_stmnt, UPPER(batch_sql_stmnt), currency_code, select_clause
2579: FROM csc_prof_blocks_b a
2580: WHERE a.block_id = sel_blk_id;
2581:
2582: Cursor val_csr3 IS
2583: Select Range_Low_Value, Range_High_Value

Line 3032: FROM csc_prof_blocks_b b

3028: WHERE group_id = p_group_id)
3029: AND select_type = 'B'
3030: AND check_level IN ('PARTY','ACCOUNT')
3031: AND EXISTS (SELECT null
3032: FROM csc_prof_blocks_b b
3033: WHERE a.select_block_id = b.block_id
3034: AND b.batch_sql_stmnt IS NULL)
3035: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
3036: AND Nvl(end_date_active, SYSDATE);

Line 3053: FROM csc_prof_blocks_b a

3049: AND status = 'A' ;
3050:
3051: CURSOR block_csr IS
3052: SELECT block_id, sql_stmnt, currency_code
3053: FROM csc_prof_blocks_b a
3054: WHERE a.block_id = sel_blk_id;
3055:
3056: cid number;
3057: val VARCHAR2(240) := null;

Line 3369: FROM csc_prof_blocks_b a

3365: AND status = 'A' ;
3366:
3367: CURSOR block_csr IS
3368: SELECT block_id, sql_stmnt, currency_code
3369: FROM csc_prof_blocks_b a
3370: WHERE a.block_id = sel_blk_id;
3371:
3372: cid number;
3373: val VARCHAR2(240) := null;

Line 4223: FROM csc_prof_blocks_b a

4219:
4220: -- cursor to run all blocks
4221: CURSOR blocks_csr IS
4222: SELECT block_id, sql_stmnt, currency_code
4223: FROM csc_prof_blocks_b a
4224: WHERE exists ( Select b.block_id
4225: From csc_prof_check_rules_b b
4226: where b.block_id = a.block_id
4227: or b.expr_to_block_id = a.block_id)

Line 4421: FROM csc_prof_blocks_b a

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

Line 4607: FROM csc_prof_blocks_b

4603:
4604: -- cursor to run a specific block
4605: CURSOR blocks_csr IS
4606: SELECT block_id, sql_stmnt, currency_code
4607: FROM csc_prof_blocks_b
4608: WHERE block_id = p_block_id
4609: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
4610: AND Nvl(end_date_active, Sysdate));
4611:

Line 4787: FROM csc_prof_blocks_b a

4783:
4784: -- cursor to run all blocks for all checks present in that group
4785: CURSOR blocks_csr IS
4786: SELECT block_id, sql_stmnt, currency_code
4787: FROM csc_prof_blocks_b a
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)

Line 4992: FROM csc_prof_blocks_b a

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

Line 5172: FROM csc_prof_blocks_b

5168:
5169: -- cursor to run a specific block
5170: CURSOR blocks_csr(c_block_id IN NUMBER) IS
5171: SELECT block_id, sql_stmnt, currency_code
5172: FROM csc_prof_blocks_b
5173: WHERE block_id = c_block_id
5174: AND block_level in( 'CONTACT','EMPLOYEE')
5175: AND (Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5176: AND Nvl(end_date_active, Sysdate));

Line 5255: FROM csc_prof_blocks_b a

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

Line 5268: FROM csc_prof_blocks_b a

5264: AND block_level = 'CONTACT';
5265: ELSIF p_rule_only = 'Y' THEN
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)

Line 5281: FROM csc_prof_blocks_b a

5277: AND block_level ='CONTACT';
5278: ELSE
5279: OPEN v_block_curvar FOR
5280: SELECT block_id, sql_stmnt, currency_code
5281: FROM csc_prof_blocks_b a
5282: WHERE exists ( Select b.block_id
5283: From csc_prof_check_rules_b b
5284: where b.block_id = a.block_id
5285: or b.expr_to_block_id = a.block_id)

Line 5294: FROM csc_prof_blocks_b a

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

Line 5308: FROM csc_prof_blocks_b a

5304: AND block_level = 'CONTACT';
5305: ELSIF p_rule_only = 'Y' THEN
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)

Line 5323: FROM csc_prof_blocks_b a

5319: AND block_level = 'CONTACT';
5320: ELSE
5321: OPEN v_block_curvar FOR
5322: SELECT block_id, sql_stmnt, currency_code
5323: FROM csc_prof_blocks_b a
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)

Line 5456: FROM csc_prof_blocks_b a

5452: v_rec_var r_chk_rectype;
5453:
5454: CURSOR block_csr IS
5455: SELECT block_id, sql_stmnt, currency_code
5456: FROM csc_prof_blocks_b a
5457: WHERE a.block_id = sel_blk_id;
5458:
5459: CURSOR crelparty_csr IS
5460: SELECT party_id

Line 5484: FROM csc_prof_blocks_b b

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
5485: WHERE a.select_block_id = b.block_id
5486: AND b.batch_sql_stmnt IS NULL)
5487: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
5488: AND Nvl(end_date_active, SYSDATE);

Line 5521: FROM csc_prof_blocks_b b

5517: WHERE group_id = p_group_id)
5518: AND select_type = 'B'
5519: AND check_level = 'CONTACT'
5520: AND EXISTS (SELECT null
5521: FROM csc_prof_blocks_b b
5522: WHERE a.select_block_id = b.block_id
5523: AND b.batch_sql_stmnt IS NULL)
5524: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
5525: AND Nvl(end_date_active, SYSDATE);

Line 5715: FROM csc_prof_blocks_b a

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

Line 5728: FROM csc_prof_blocks_b a

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

Line 5741: FROM csc_prof_blocks_b a

5737: AND block_level ='EMPLOYEE';
5738: ELSE
5739: OPEN v_block_curvar FOR
5740: SELECT block_id, sql_stmnt, currency_code
5741: FROM csc_prof_blocks_b a
5742: WHERE exists ( Select b.block_id
5743: From csc_prof_check_rules_b b
5744: where b.block_id = a.block_id
5745: or b.expr_to_block_id = a.block_id)

Line 5754: FROM csc_prof_blocks_b a

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

Line 5768: FROM csc_prof_blocks_b a

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

Line 5783: FROM csc_prof_blocks_b a

5779: AND block_level = 'EMPLOYEE';
5780: ELSE
5781: OPEN v_block_curvar FOR
5782: SELECT block_id, sql_stmnt, currency_code
5783: FROM csc_prof_blocks_b a
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)

Line 5917: FROM csc_prof_blocks_b a

5913: v_rec_var r_chk_rectype;
5914:
5915: CURSOR block_csr IS
5916: SELECT block_id, sql_stmnt, currency_code
5917: FROM csc_prof_blocks_b a
5918: WHERE a.block_id = sel_blk_id;
5919:
5920: CURSOR employee_csr IS
5921: SELECT person_id

Line 5944: FROM csc_prof_blocks_b b

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
5945: WHERE a.select_block_id = b.block_id
5946: AND b.batch_sql_stmnt IS NULL)
5947: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
5948: AND Nvl(end_date_active, SYSDATE);

Line 5981: FROM csc_prof_blocks_b b

5977: WHERE group_id = p_group_id)
5978: AND select_type = 'B'
5979: AND check_level = 'EMPLOYEE'
5980: AND EXISTS (SELECT null
5981: FROM csc_prof_blocks_b b
5982: WHERE a.select_block_id = b.block_id
5983: AND b.batch_sql_stmnt IS NULL)
5984: AND SYSDATE BETWEEN Nvl(start_date_active, SYSDATE)
5985: AND Nvl(end_date_active, SYSDATE);

Line 7576: csc_prof_blocks_b

7572: WHERE check_id = chk_id;
7573:
7574: cursor blk_crs is
7575: select block_level from
7576: csc_prof_blocks_b
7577: where block_id=v_blk_id;
7578:
7579: BEGIN
7580: --