1197: l_charge_basis,
1198: l_charge_basis_uom,
1199: x_fac_info_rows(k).fac_currency
1200: FROM fte_location_parameters fl,
1201: fte_prc_parameters prc_cbasis,
1202: fte_prc_parameters prc_cbasis_uom,
1203: fte_prc_parameters prc_currency,
1204: fte_prc_parameters prc_rc_id
1205: WHERE fl.location_id = x_fac_info_rows(k).location_id
1198: l_charge_basis_uom,
1199: x_fac_info_rows(k).fac_currency
1200: FROM fte_location_parameters fl,
1201: fte_prc_parameters prc_cbasis,
1202: fte_prc_parameters prc_cbasis_uom,
1203: fte_prc_parameters prc_currency,
1204: fte_prc_parameters prc_rc_id
1205: WHERE fl.location_id = x_fac_info_rows(k).location_id
1206: AND prc_cbasis.list_header_id(+) = fl.modifier_list
1199: x_fac_info_rows(k).fac_currency
1200: FROM fte_location_parameters fl,
1201: fte_prc_parameters prc_cbasis,
1202: fte_prc_parameters prc_cbasis_uom,
1203: fte_prc_parameters prc_currency,
1204: fte_prc_parameters prc_rc_id
1205: WHERE fl.location_id = x_fac_info_rows(k).location_id
1206: AND prc_cbasis.list_header_id(+) = fl.modifier_list
1207: AND prc_cbasis_uom.list_header_id(+)= fl.modifier_list
1200: FROM fte_location_parameters fl,
1201: fte_prc_parameters prc_cbasis,
1202: fte_prc_parameters prc_cbasis_uom,
1203: fte_prc_parameters prc_currency,
1204: fte_prc_parameters prc_rc_id
1205: WHERE fl.location_id = x_fac_info_rows(k).location_id
1206: AND prc_cbasis.list_header_id(+) = fl.modifier_list
1207: AND prc_cbasis_uom.list_header_id(+)= fl.modifier_list
1208: AND prc_currency.list_header_id(+) = fl.modifier_list