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 1973: FROM csc_prof_check_rules_b

1969:
1970: -- cursor to get the blocks related to the check
1971: CURSOR cblocks_csr IS
1972: SELECT DISTINCT block_id
1973: FROM csc_prof_check_rules_b
1974: WHERE check_id = chk_id
1975: UNION
1976: (SELECT DISTINCT expr_to_block_id
1977: FROM csc_prof_check_rules_b

Line 1977: FROM csc_prof_check_rules_b

1973: FROM csc_prof_check_rules_b
1974: WHERE check_id = chk_id
1975: UNION
1976: (SELECT DISTINCT expr_to_block_id
1977: FROM csc_prof_check_rules_b
1978: WHERE check_id = chk_id
1979: );
1980: CURSOR block_csr IS
1981: SELECT block_id,

Line 2791: From csc_prof_check_rules_b

2787:
2788: -- cursor to get the blocks related to the check
2789: CURSOR cblocks_csr IS
2790: Select distinct block_id
2791: From csc_prof_check_rules_b
2792: Where check_id = chk_id
2793: UNION
2794: (Select distinct expr_to_block_id
2795: From csc_prof_check_rules_b

Line 2795: From csc_prof_check_rules_b

2791: From csc_prof_check_rules_b
2792: Where check_id = chk_id
2793: UNION
2794: (Select distinct expr_to_block_id
2795: From csc_prof_check_rules_b
2796: Where check_id = chk_id);
2797:
2798: CURSOR block_csr IS
2799: SELECT block_id,

Line 5825: From csc_prof_check_rules_b b

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

Line 6714: From csc_prof_check_rules_b b

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)
6717: And check_id in (Select check_id
6718: from csc_prof_group_checks

Line 7494: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

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)
7497: AND c.select_type = 'T'
7498: AND b.check_id = c.check_id)

Line 7509: From csc_prof_check_rules_b b

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

Line 7540: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

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)
7543: AND c.select_type = 'T'
7544: AND b.check_id = c.check_id

Line 7557: FROM csc_prof_check_rules_b b

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

Line 8188: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

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)
8191: AND c.select_type = 'T'
8192: AND b.check_id = c.check_id)

Line 8201: From csc_prof_check_rules_b b

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

Line 8228: FROM csc_prof_check_rules_b b, csc_prof_checks_b c

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)
8231: AND c.select_type = 'T'
8232: AND b.check_id = c.check_id

Line 8243: FROM csc_prof_check_rules_b b

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