DBA Data[Home] [Help]

APPS.OKS_CCMIGRATE_PVT dependencies on OKC_RULE_GROUPS_B

Line 2669: , okc_rule_groups_b rg

2665: (SELECT /*+ no_merge parallel(khdr) */ ID, FLOOR((ROWNUM-1)/l_bucket_size) Worker_Bucket
2666: FROM
2667: ( Select rl.Id
2668: From okc_rules_b rl
2669: , okc_rule_groups_b rg
2670: , Oks_k_headers_b Kh
2671: Where rl.rgp_id = rg.id
2672: And rl.rule_information_category = 'CCR'
2673: And rl.rule_information1 is not null

Line 3030: , okc_rule_groups_b rg

3026:
3027: Cursor l_hdr_rule_csr Is
3028: Select rl.Id
3029: From okc_rules_b rl
3030: , okc_rule_groups_b rg
3031: , Oks_k_headers_b Kh
3032: Where rl.rgp_id = rg.id
3033: And rl.rule_information_category = 'CCR'
3034: And rl.rule_information1 is not null