DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKC_RULES_B

Line 1109: okc_rules_b rulb,

1105: cursor l_rela_csr (p_subsidy_id in number,
1106: p_asset_cle_id in number) is
1107: Select 'Y'
1108: from okl_subsidies_b sub,
1109: okc_rules_b rulb,
1110: okc_k_lines_b cleb
1111: where sub.id = p_subsidy_id
1112: and rulb.dnz_chr_id = cleb.chr_id
1113: and rulb.rule_information_category = 'LARLES'

Line 1126: from okc_rules_b rulb

1122: okc_k_lines_b cleb
1123: where sub.id = p_subsidy_id
1124: and cleb.id = p_asset_cle_id
1125: and not exists (select 1
1126: from okc_rules_b rulb
1127: where rulb.dnz_chr_id = cleb.chr_id
1128: and rulb.rule_information_category = 'LARLES');
1129:
1130: