APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_INVC_FRMT_STRMS_V

Line 3188: okl_invc_frmt_strms_v frs,

3184: sty.name sty_name
3185: FROM okl_invoice_formats_v inf,
3186: okl_invoice_types_v ity,
3187: okl_invc_line_types_v ilt,
3188: okl_invc_frmt_strms_v frs,
3189: okl_strm_type_v sty
3190: WHERE inf.id = p_format_id
3191: AND ity.inf_id = inf.id
3192: AND ilt.ity_id = ity.id

Line 3256: okl_invc_frmt_strms_v frs,

3252: frs.sty_id sty_id
3253: FROM okl_invoice_formats_v inf,
3254: okl_invoice_types_v ity,
3255: okl_invc_line_types_v ilt,
3256: okl_invc_frmt_strms_v frs,
3257: okl_strm_type_v sty
3258: WHERE ity.inf_id = inf.id
3259: AND ilt.ity_id = ity.id
3260: AND frs.ilt_id = ilt.id

Line 3294: sty_id okl_invc_frmt_strms_v.sty_id%type);

3290: ilt_id okl_invc_line_types_v.id%type,
3291: sequence_number okl_invc_line_types_v.sequence_number%type,
3292: ilt_name okl_invc_line_types_v.name%type,
3293: sty_name okl_strm_type_v.name%type,
3294: sty_id okl_invc_frmt_strms_v.sty_id%type);
3295:
3296: TYPE inv_format_table IS TABLE OF inv_format_type
3297: INDEX BY BINARY_INTEGER;
3298:

Line 3303: l_sty_id okl_invc_frmt_strms_v.sty_id%type;

3299: l_inv_format_table inv_format_table;
3300: l_lln_tbl lln_tbl_type;
3301: l_line_counter NUMBER := 0;
3302: l_inf_id okl_invoice_formats_v.id%type;
3303: l_sty_id okl_invc_frmt_strms_v.sty_id%type;
3304: l_loop_counter NUMBER := 0;
3305: l_asset_counter NUMBER := 0;
3306:
3307: -- fmiao - Bug#5232919 - Modified - Start