APPS.OKL_INTERNAL_BILLING_PVT dependencies on OKC_RULE_GROUPS_B

Line 262: l_rgd_code okc_rule_groups_b.rgd_code%TYPE DEFAULT NULL;

258: is
259: l_api_name CONSTANT VARCHAR2(30) := 'additional_tai_attr';
260: l_api_version CONSTANT NUMBER := 1.0;
261: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
262: l_rgd_code okc_rule_groups_b.rgd_code%TYPE DEFAULT NULL;
263:
264: --START: cklee 3/20/07
265: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
266:

Line 279: FROM okc_rule_groups_b

275: object1_id2
276: FROM okc_rules_b
277: WHERE rgp_id =
278: (SELECT id
279: FROM okc_rule_groups_b
280: WHERE dnz_chr_id = p_khr_id
281: AND cle_id IS NULL
282: AND rgd_code = p_rgd_code)
283: AND rule_information_category = p_rule_category;

Line 293: FROM okc_rule_groups_b rgp,

289: object1_id2
290: FROM okc_rules_b
291: WHERE rgp_id =
292: (SELECT rgp.id
293: FROM okc_rule_groups_b rgp,
294: okc_rg_party_roles rpr
295: WHERE rgp.dnz_chr_id = p_khr_id
296: AND rgp.cle_id IS NULL
297: AND rgp.rgd_code = p_rgd_code

Line 427: FROM okc_rule_groups_b a,

423: -- AR. Bug 4525643
424: -- -------------------------------------------
425: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
426: SELECT rule_information1 private_label
427: FROM okc_rule_groups_b a,
428: okc_rules_b b
429: WHERE a.dnz_chr_id = cp_khr_id
430: AND a.rgd_code = 'LALABL'
431: AND a.id = b.rgp_id