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_CHECK_RULES_B

Line 1511: FROM csc_prof_check_rules_b

1507:
1508: -- cursor to get the blocks related to the check
1509: CURSOR cblocks_csr IS
1510: SELECT distinct block_id
1511: FROM csc_prof_check_rules_b
1512: WHERE check_id = chk_id
1513: UNION
1514: (SELECT distinct expr_to_block_id
1515: FROM csc_prof_check_rules_b

Line 1515: FROM csc_prof_check_rules_b

1511: FROM csc_prof_check_rules_b
1512: WHERE check_id = chk_id
1513: UNION
1514: (SELECT distinct expr_to_block_id
1515: FROM csc_prof_check_rules_b
1516: WHERE check_id = chk_id);
1517:
1518: CURSOR block_csr IS
1519: SELECT block_id, sql_stmnt, currency_code

Line 2073: From csc_prof_check_rules_b

2069:
2070: -- cursor to get the blocks related to the check
2071: CURSOR cblocks_csr IS
2072: Select distinct block_id
2073: From csc_prof_check_rules_b
2074: Where check_id = chk_id
2075: UNION
2076: (Select distinct expr_to_block_id
2077: From csc_prof_check_rules_b

Line 2077: From csc_prof_check_rules_b

2073: From csc_prof_check_rules_b
2074: Where check_id = chk_id
2075: UNION
2076: (Select distinct expr_to_block_id
2077: From csc_prof_check_rules_b
2078: Where check_id = chk_id);
2079:
2080: CURSOR block_csr IS
2081: SELECT block_id, sql_stmnt, currency_code

Line 4225: From csc_prof_check_rules_b b

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)
4228: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
4229: AND Nvl(end_date_active, Sysdate)

Line 4789: From csc_prof_check_rules_b b

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)
4792: And check_id in (Select check_id from csc_prof_group_checks
4793: where group_id = p_group_id))

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 5283: From csc_prof_check_rules_b b

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)
5286: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5287: AND Nvl(end_date_active, Sysdate)

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 5325: FROM csc_prof_check_rules_b b

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)
5328: AND check_id IN (Select check_id from csc_prof_group_checks
5329: where group_id = p_group_id))

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 5743: From csc_prof_check_rules_b b

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)
5746: AND Sysdate BETWEEN Nvl(start_date_active, Sysdate)
5747: AND Nvl(end_date_active, Sysdate)

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 5785: FROM csc_prof_check_rules_b b

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)
5788: AND check_id IN (Select check_id from csc_prof_group_checks
5789: where group_id = p_group_id))