DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKC_RULES_V

Line 1545: okc_rules_v rul

1541: CURSOR inv_frmt_csr(cp_khr_id IN NUMBER) IS
1542: SELECT to_number(rul.rule_information1), --inf.id, --sechawla 26-may-09 6826580
1543: rul.rule_information4 review_invoice_yn
1544: FROM okc_rule_groups_v rgp,
1545: okc_rules_v rul
1546: -- ,okl_invoice_formats_v inf --sechawla 26-may-09 6826580
1547: WHERE rgp.dnz_chr_id = cp_khr_id AND
1548: rgp.chr_id = rgp.dnz_chr_id AND
1549: rgp.id = rul.rgp_id AND

Line 1568: l_review_invoice_yn okc_rules_v.rule_information4%type;

1564: l_request_id NUMBER(15);
1565: l_program_application_id NUMBER(15);
1566: l_program_id NUMBER(15);
1567: l_program_update_date DATE;
1568: l_review_invoice_yn okc_rules_v.rule_information4%type;
1569:
1570: -- -------------------------------------------
1571: -- To support private label transfers to
1572: -- AR. Bug 4525643