APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 125: l_inf_id okl_invoice_formats_v.id%TYPE;

121: l_currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE;
122: l_func_curr_code OKL_EXT_SELL_INVS_B.currency_code%TYPE;
123:
124:
125: l_inf_id okl_invoice_formats_v.id%TYPE;
126: l_private_label okc_rules_b.Rule_information1%type;
127: -- End Bug 4540379
128:
129: -- For PPD process error reporting

Line 1546: -- ,okl_invoice_formats_v inf --sechawla 26-may-09 6826580

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
1550: rgp.cle_id IS NULL AND

Line 1556: --l_inf_id okl_invoice_formats_v.id%TYPE;

1552: rul.rule_information_category = 'LAINVD' ;
1553: -- AND rul.rule_information1 = inf.name;
1554:
1555: -- Bug 4540379
1556: --l_inf_id okl_invoice_formats_v.id%TYPE;
1557: -- End Bug 4540379
1558:
1559: CURSOR get_languages IS
1560: SELECT *