APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKC_RULE_GROUPS_V

Line 446: FROM okc_rule_groups_v rgp,

442: AND role.rle_code = 'LESSEE';
443:
444: CURSOR okl_bill_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
445: SELECT rule.object1_id1
446: FROM okc_rule_groups_v rgp,
447: okc_rules_v rule
448: WHERE rgp.chr_id = p_chr_id
449: AND rgp.id = rule.rgp_id
450: AND rgp.rgd_code = 'LABILL'

Line 2971: okc_rule_groups_v rg

2967:
2968: CURSOR arintf_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2969: SELECT rule.id
2970: FROM okc_rules_v rule,
2971: okc_rule_groups_v rg
2972: WHERE rule.rgp_id = rg.id
2973: AND rule.rule_information_category = 'SBG'
2974: AND rule.jtot_object1_code = 'OKS_TRXTYPE'
2975: AND rg.chr_id = p_chr_id;