DBA Data[Home] [Help]

APPS.OKL_INTERNAL_BILLING_PVT dependencies on OKC_RULE_GROUPS_B

Line 273: FROM okc_rule_groups_b

269: object1_id2
270: FROM okc_rules_b
271: WHERE rgp_id =
272: (SELECT id
273: FROM okc_rule_groups_b
274: WHERE dnz_chr_id = p_khr_id
275: AND cle_id IS NULL
276: AND rgd_code = 'LABILL')
277: AND rule_information_category = p_rule_category;

Line 403: FROM okc_rule_groups_b a,

399: -- AR. Bug 4525643
400: -- -------------------------------------------
401: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
402: SELECT rule_information1 private_label
403: FROM okc_rule_groups_b a,
404: okc_rules_b b
405: WHERE a.dnz_chr_id = cp_khr_id
406: AND a.rgd_code = 'LALABL'
407: AND a.id = b.rgp_id