APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 123: l_inf_id okl_invoice_formats_v.id%TYPE;

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

Line 1483: okl_invoice_formats_v inf

1479: SELECT inf.id,
1480: rul.rule_information4 review_invoice_yn
1481: FROM okc_rule_groups_v rgp,
1482: okc_rules_v rul,
1483: okl_invoice_formats_v inf
1484: WHERE rgp.dnz_chr_id = cp_khr_id AND
1485: rgp.chr_id = rgp.dnz_chr_id AND
1486: rgp.id = rul.rgp_id AND
1487: rgp.cle_id IS NULL AND

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

1489: rul.rule_information_category = 'LAINVD' AND
1490: rul.rule_information1 = inf.name;
1491:
1492: -- Bug 4540379
1493: --l_inf_id okl_invoice_formats_v.id%TYPE;
1494: -- End Bug 4540379
1495:
1496: CURSOR get_languages IS
1497: SELECT *