APPS.OKL_CONS_BILL dependencies on OKL_INVOICE_FORMATS_V

Line 975: l_format_name okl_invoice_formats_v.name%TYPE;

971: IS
972:
973:
974: l_api_name CONSTANT VARCHAR2(30) := 'process_cons_bill_tbl';
975: l_format_name okl_invoice_formats_v.name%TYPE;
976: l_contract_level_yn VARCHAR2(3);
977: l_group_asset_yn VARCHAR2(3);
978: l_group_by_contract_yn VARCHAR2(3);
979: l_ilt_id NUMBER;

Line 1055: FROM okl_invoice_formats_v inf,

1051: ilt.id ilt_id,
1052: ilt.sequence_number,
1053: ilt.name ilt_name,
1054: sty.name sty_name
1055: FROM okl_invoice_formats_v inf,
1056: okl_invoice_types_v ity,
1057: okl_invc_line_types_v ilt,
1058: okl_invc_frmt_strms_v frs,
1059: okl_strm_type_v sty

Line 1078: FROM okl_invoice_formats_v inf,

1074: ity.group_by_contract_yn,
1075: ilt.id ilt_id,
1076: ilt.sequence_number,
1077: ilt.name ilt_name
1078: FROM okl_invoice_formats_v inf,
1079: okl_invoice_types_v ity,
1080: okl_invc_line_types_v ilt
1081: WHERE inf.id = p_format_id
1082: AND ity.inf_id = inf.id

Line 1087: l_invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE;

1083: AND ilt.ity_id = ity.id
1084: AND inf.ilt_id = ilt.id;
1085:
1086: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;
1087: l_invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE;
1088: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
1089:
1090: l_old_cnr_id NUMBER;
1091: l_old_lln_id NUMBER;

Line 1908: FROM okl_invoice_formats_v

1904: ORDER BY sequence_number;
1905:
1906: CURSOR format_id_csr (p_format_name VARCHAR2) IS
1907: SELECT id
1908: FROM okl_invoice_formats_v
1909: WHERE name = p_format_name;
1910:
1911: CURSOR asset_line_csr (p_lsm_id NUMBER) IS
1912: SELECT ASSET_NUMBER