DBA Data[Home] [Help]

APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKC_RULE_GROUPS_B

Line 1224: okc_rule_groups_b rgp

1220: SELECT COUNT(*)
1221: FROM okc_rules_b sll_rul,
1222: okl_strmtyp_source_v sttyp,
1223: okc_rules_b slh_rul,
1224: okc_rule_groups_b rgp
1225: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)
1226: AND sll_rul.rgp_id = rgp.id
1227: AND sll_rul.rule_information_category = 'LASLL'
1228: AND sttyp.id1 = slh_rul.object1_id1

Line 1266: okc_rule_groups_b rgp

1262: FROM okl_time_units_v tuom,
1263: okc_rules_b sll_rul,
1264: okl_strmtyp_source_v sttyp,
1265: okc_rules_b slh_rul,
1266: okc_rule_groups_b rgp
1267: WHERE tuom.id1 = sll_rul.object1_id1
1268: AND sll_rul.object2_id1 = to_char(slh_rul.id)
1269: AND sll_rul.rgp_id = rgp.id
1270: AND sll_rul.rule_information_category = 'LASLL'

Line 2473: okc_rule_groups_b rgp

2469: SELECT sum(sll_rul.rule_information8)
2470: FROM okc_rules_b sll_rul,
2471: okl_strmtyp_source_v sttyp,
2472: okc_rules_b slh_rul,
2473: okc_rule_groups_b rgp
2474: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)
2475: AND sll_rul.rgp_id = rgp.id
2476: AND sll_rul.rule_information_category = 'LASLL'
2477: AND sttyp.id1 = slh_rul.object1_id1

Line 4699: okc_rule_groups_b rgp

4695: SELECT COUNT(*)
4696: FROM okc_rules_b sll_rul,
4697: okl_strmtyp_source_v sttyp,
4698: okc_rules_b slh_rul,
4699: okc_rule_groups_b rgp
4700: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)
4701: AND sll_rul.rgp_id = rgp.id
4702: AND sll_rul.rule_information_category = 'LASLL'
4703: AND sttyp.id1 = slh_rul.object1_id1

Line 7221: okc_rule_groups_b rgp

7217: FROM okl_time_units_v tuom,
7218: okc_rules_b sll_rul,
7219: okl_strmtyp_source_v sttyp,
7220: okc_rules_b slh_rul,
7221: okc_rule_groups_b rgp
7222: WHERE tuom.id1 = sll_rul.object1_id1
7223: AND sll_rul.object2_id1 = to_char(slh_rul.id)
7224: AND sll_rul.rgp_id = rgp.id
7225: AND sll_rul.rule_information_category = 'LASLL'

Line 7240: okc_rule_groups_b rgp

7236: FROM okl_time_units_v tuom,
7237: okc_rules_b sll_rul,
7238: okl_strmtyp_source_v sttyp,
7239: okc_rules_b slh_rul,
7240: okc_rule_groups_b rgp
7241: WHERE tuom.id1 = sll_rul.object1_id1
7242: AND sll_rul.object2_id1 = to_char(slh_rul.id)
7243: AND sll_rul.rgp_id = rgp.id
7244: AND sll_rul.rule_information_category = 'LASLL'

Line 7259: okc_rule_groups_b rgp

7255: FROM okl_time_units_v tuom,
7256: okc_rules_b sll_rul,
7257: okl_strmtyp_source_v sttyp,
7258: okc_rules_b slh_rul,
7259: okc_rule_groups_b rgp
7260: WHERE tuom.id1 = sll_rul.object1_id1
7261: AND sll_rul.object2_id1 = to_char(slh_rul.id)
7262: AND sll_rul.rgp_id = rgp.id
7263: AND sll_rul.rule_information_category = 'LASLL'