APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_INVC_FRMT_STRMS_V

Line 3124: okl_invc_frmt_strms_v frs,

3120: sty.name sty_name
3121: FROM okl_invoice_formats_v inf,
3122: okl_invoice_types_v ity,
3123: okl_invc_line_types_v ilt,
3124: okl_invc_frmt_strms_v frs,
3125: okl_strm_type_v sty
3126: WHERE inf.id = p_format_id
3127: AND ity.inf_id = inf.id
3128: AND ilt.ity_id = ity.id

Line 3192: okl_invc_frmt_strms_v frs,

3188: frs.sty_id sty_id
3189: FROM okl_invoice_formats_v inf,
3190: okl_invoice_types_v ity,
3191: okl_invc_line_types_v ilt,
3192: okl_invc_frmt_strms_v frs,
3193: okl_strm_type_v sty
3194: WHERE ity.inf_id = inf.id
3195: AND ilt.ity_id = ity.id
3196: AND frs.ilt_id = ilt.id

Line 3230: sty_id okl_invc_frmt_strms_v.sty_id%type);

3226: ilt_id okl_invc_line_types_v.id%type,
3227: sequence_number okl_invc_line_types_v.sequence_number%type,
3228: ilt_name okl_invc_line_types_v.name%type,
3229: sty_name okl_strm_type_v.name%type,
3230: sty_id okl_invc_frmt_strms_v.sty_id%type);
3231:
3232: TYPE inv_format_table IS TABLE OF inv_format_type
3233: INDEX BY BINARY_INTEGER;
3234:

Line 3239: l_sty_id okl_invc_frmt_strms_v.sty_id%type;

3235: l_inv_format_table inv_format_table;
3236: l_lln_tbl lln_tbl_type;
3237: l_line_counter NUMBER := 0;
3238: l_inf_id okl_invoice_formats_v.id%type;
3239: l_sty_id okl_invc_frmt_strms_v.sty_id%type;
3240: l_loop_counter NUMBER := 0;
3241: l_asset_counter NUMBER := 0;
3242:
3243: -- fmiao - Bug#5232919 - Modified - Start