APPS.OKL_INTERNAL_BILLING_PVT dependencies on OKC_RULES_B

Line 261: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;

257:
258: --START: cklee 3/20/07
259: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
260:
261: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
262: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
263: l_object1_id1 okc_rules_b.object1_id1%TYPE;
264: l_object1_id2 okc_rules_b.object1_id2%TYPE;
265:

Line 262: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;

258: --START: cklee 3/20/07
259: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
260:
261: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
262: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
263: l_object1_id1 okc_rules_b.object1_id1%TYPE;
264: l_object1_id2 okc_rules_b.object1_id2%TYPE;
265:
266: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS

Line 263: l_object1_id1 okc_rules_b.object1_id1%TYPE;

259: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
260:
261: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
262: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
263: l_object1_id1 okc_rules_b.object1_id1%TYPE;
264: l_object1_id2 okc_rules_b.object1_id2%TYPE;
265:
266: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
267: SELECT jtot_object1_code,

Line 264: l_object1_id2 okc_rules_b.object1_id2%TYPE;

260:
261: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
262: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
263: l_object1_id1 okc_rules_b.object1_id1%TYPE;
264: l_object1_id2 okc_rules_b.object1_id2%TYPE;
265:
266: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
267: SELECT jtot_object1_code,
268: object1_id1,

Line 270: FROM okc_rules_b

266: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
267: SELECT jtot_object1_code,
268: object1_id1,
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

Line 404: okc_rules_b b

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
408: AND b.rule_information_category = 'LALOGO';

Line 410: l_private_label okc_rules_b.rule_information1%TYPE;

406: AND a.rgd_code = 'LALABL'
407: AND a.id = b.rgp_id
408: AND b.rule_information_category = 'LALOGO';
409:
410: l_private_label okc_rules_b.rule_information1%TYPE;
411:
412: --END: cklee 3/20/07
413:
414: begin